• http://www.facebook.com/profile.php?id=507536131 Michael Shostack

    This is a helpful guide for entry-level folks.

    For anyone who has basic knowledge of Excel formatting, I would recommend spending some time perusing Chandu’s site @ http://chandoo.org/wp/excel-dashboards/ (this link is for his Dashboards section which is awesome).

    He also offers Excel file downloads for quite a bit of this sort of stuff.

  • http://twitter.com/AnnieCushing Annie Cushing

    Nice resource, Michael! Evernoted.

  • http://charliesaidthat.com/digital charliesaidthat

    Ctrl+A, Ctrl+L – Beautiful.  :)

  • http://www.niceoppai.net/ Niceoppai

    very useful thank you

  • http://www.seogenx.com/ Nandkishor

    I would like to use this feature especially when I have to send report to clients before it gets analyzed. It’s time saving. When there are huge list of keywords, to separate them by different scenario, e.g. long tails, search volumes, competitivenes, makes all easy for me by this tool. I truly recommend this tool and off course Guide to use :-) to one who haven’t used yet.

  • http://ratefacter.org.ua/ Marchenko Ruslan

    Thank you for a great post. Excel has always been a weak side of mine. But not anymore! Fishkin shared this post via G+, and he did a good deal, i think

  • http://www.indigomediaconsulting.com/ Nichole

    Thanks for the post Annie! I always love learning fun, new ways to play with data.

  • Cesar Montesdeoca

    Great article, this is the kind of info that may the web great.

  • Brian Callaghan

    It would be nice if you could make this a default for all new spreadsheets

  • SEER Reynolds

    There are more to come, Marchenko. I just finished a post on pivot tables. It’ll go live next Friday. :)

  • http://twitter.com/AnnieCushing Annie Cushing

    I agree, Brian. I’ve searched long and hard for a way to do that. Microsoft really needs to add that functionality. They offer it for charts; it would stand to reason they could add it for tables. Sigh.

  • http://twitter.com/AnnieCushing Annie Cushing

    Great. I think you’ll really enjoy the series then. :)

  • Maggie Holley

    Thanks Annie for this guide and also your Tools list on Google Docs I just found..Wow!
    Even though I need to do this stuff, I resist it a little ..Mindset! LOL
    This will help. Great work.

  • Maggie Holley

    Thanks Annie for this guide and also your Tools list on Google Docs I just found..Wow!
    Even though I need to do this stuff, I resist it a little ..Mindset! LOL
    This will help. Great work.

  • http://twitter.com/AnnieCushing Annie Cushing

    You’re welcome, Maggie! Glad to help the community any way I can. :)