Visit www.netresulttr... for more tutorials on Microsoft Office Training. In this video we take a number of keywords and analyse them for competition and search volume using Google Adwords and Excel.
Maximizing the most basic things that you have in your computer will not just help you save time and money. It will also hone your skills in the next endeavors that you are planning to take. Everybody in this industry is almost familiar with this program. Thanks for this video because it really showed us how to do it.
Hi Md.Saddam Hossain, you can see the formula if you stop the video at 3.25. In the case of column D the formula is =IF(AND(B2=100000),1,""). Basically, we are testing cells B2 and C2 to make sure they both meet the criteria i.e. that B2 is less than 79% and C2 is more than 100,000. We need both of these to be true, and if they are we tell Excel to put a 1 in cell D2. While the maths is still OK and the formula still current, please be aware that this video is over 6 years old. Google, and keyword research has moved on a long way since I made this video - use at your own risk.
Hi David, not sure I understand the question - are you referring to the Competition and Global Monthly searches fields? Don't forget, this video is over 4 years old and things have changed somewhat in terms of SEO. The principle in Excel are still good though, which is why I have left it up.