This article is contributed by Atiq Rehman.
What if you’re not an Excel expert? This is your guide. It was initially intended for SEO people, though many will find it useful.
For each one we’ve included a simple SEO based example of it in use. We’ve also included notes on it’s uses for day-to-day SEO work and a link or two to useful more technical articles.
There is also an appendix. It contains a beginners guide to error checking, a list of the 17 Excel shortcuts that you’ll actually use day-to-day, links to some great Excel sites if you want to find out more and finally a brief note on SEO Tools For Excel, an SEO focused Excel add-in.