Find Niche Markets Online | Vince Quattrin

This tutorial is continued with full written instructions at WordPressVideos.TV Now, if you have already done your keyword research using various different tools and software, then make sure you have copied and pasted all those keywords into a single Excel file, preferably with a header, as we see here, so you know which column stands for what kind of data. The first thing you want to do is create a filter for the first column, okay, so you can see that now, I can actually filter my data for each individual column, and the next thing youll want to do is freeze this entire first column. So to do that, Im just gonna click on View, then Im gonna click on Freeze Panes, Freeze Top Row. Okay. So now, you can see that I can continue to scroll down my massive list of keywords which I have about 401 keywords here. And at the same time, this first row is frozen, so it really makes it very easy for me to have a look at my data and understand what all those numbers mean. So the first thing you should do is to eliminate any exact duplicates. And to do that, Im going to sort this list from A to Z. And because Ive used a few different types of keyword software, I may end up with a lot of duplicates, so you could just highlight the duplicates, alright, and you can just delete those. By duplicates, I mean of course that the keyword is exactly the same and the data that you get for those keywords also very, very similar. And those are considered duplicates, and logically, you do not need …