October 29, 2010
I hate excel. It has to be said. However we use excel everyday for everything, simple calculations, records of rankings, doing keyword research etc. One of the things that I had to do this week is compare monthly search volume on certain keywords and plot it against current rankings into a graph.
Sounds easy, and it IS easy and there are resources like Rich Baxter’s tutorial that shows you how to do it – but I just wasn’t following half way. 🙁 It is no doubt an awesome tutorial that probably took ages to do and I appreciate that – this post on the other hand, is kinda like an extension of that post, if you will, but for really slow folks like me who need to go through every single step slowly, understand it and then have screenshots in front of my face for every click.
Like for example, Rich has revealed the VLOOKUP function code: =VLOOKUP(A2,rankings!$A$1:$B$13,2,0) and tried to explain what all these weird numbers and letters mean. But it didn’t register with me. And also, I need to know what every segment of the code means.
Then there’s that dreaded pivot table thing that looks cool and all but I got lost halfway in the middle of all the geeky references of “array” “format” “seconday axis” etc due to my dyspraxia. But I got there in the end. So I’ve created these 2 guides with complete screenshots and explanation of every single step and click you have to do to create your Pivot Table and using VLOOKUP in excel.
[Simplyifying and Understanding VLOOKUP] (right click on the click and select save link as)
[Excel For SEOs – Pivot Tables] (right click on the click and select save link as)
Looks daunting? It really isnt!