• http://www.asktimothynorton.com/ Timothy Norton

    Great article! Most people don’t know the powerful capabilities of Excel. It actually has the same capabilities as other software which sells for thousands of dollars. Thanks for sharing these powerful, practical tips.

  • Britt Mccrimmon

    Great post. This one is going in the Google Bookmark for later!

  • Dean Marsden

    Before I started working in Digital Marketing I was a complete Excel newbie and was in fact very scared of it. I’ve re shared this post to let others know the extent to which Excel can help with our work. I agree its very important for reporting and analysis. I have to admit though, I’m still a little bit scared of this beast.

  • http://twitter.com/sammmer Sam Mazaheri

    Good stuff! I started using table formatting after one of your posts last year, but do you find that it slows down your formulas? Each cell gets a crazy name instead of the simple A1 name.

  • Bill Bean

    Not developing expertise in Excel much earlier life is one of my main professional regrets. Annie, you might yet convince me to change rectify this.

  • adam 2290

    Good stuff! I’m always looking to expand my base of knowledge with Excel (not my favorite program).

  • http://www.annielytics.com/ Annie Cushing

    You’re so right. I think most marketers use only a tiny fraction of its capacity.

  • http://www.annielytics.com/ Annie Cushing

    Thanks!

  • http://www.annielytics.com/ Annie Cushing

    You and me both, Dean! Mastery is impossible but a goal I work toward regardless.

  • http://www.annielytics.com/ Annie Cushing

    It doesn’t slow them down at all, but yes, structured referencing takes some getting used to. If you stop and look at it, it’s actually pretty intuitive.

  • http://www.annielytics.com/ Annie Cushing

    You can do it, Bill! Every new skill you learn pays off in spades.

  • http://www.annielytics.com/ Annie Cushing

    You are not alone in that sentiment. I used to hate Excel, but it was because it made no sense to me. Now I adore it.

  • Colin Guidi

    Vlookups are my life bread.

  • http://www.annielytics.com/ Annie Cushing

    Right?!? I have to marry my data with them all the time.

  • http://twitter.com/sammmer Sam Mazaheri

    Good to hear, I’ll push through, thanks!

  • localsearchguy

    Great tips. This stuff should seriously be a prerequisite to graduating high school.

    For those interested in taking Excel to the brink (web scraping, web api requests) check out this stuff.

    For the beginner to intermediate.
    http://nielsbosma.se/projects/seotools/

    For intermediate to advanced.
    https://github.com/timhall/Excel-REST

    Too intimidated by this stuff… check out this blog to refine your skills.
    http://chandoo.org/wp/

  • andrekibbe

    Anyone know a good vlookup tutorial? The ones I’ve read and watched make my eyes glaze over.

  • http://www.workwithclintbutler.com/ Clint A. Butler

    I’ll be the first to admit that Excel has always intimidated me when it
    comes to using it to it full potentiall. But clearly that is something I
    need to change. There has got to be a good resource to learn the more basic and advanced features of the software.

  • http://www.facebook.com/profile.php?id=550571817 Wayne Stephenson

    Ironically I would use Excel every day in my past life as a mechanical engineer. I would use all sorts of formulas and formatting functions to report to the directors. Shame I can’t remember a thing about it and now have bigger data sets than ever. Anyone have a good SERP template they wouldn’t mind sharing ;)

  • andrekibbe

    Look very thorough. Thanks!

  • http://www.annielytics.com/ Annie Cushing

    I just use the Remove Duplicates utility under the Data tab to remove duplicates. Or the “Unique Values Only” option if I’m using advanced filters.

  • http://www.annielytics.com/ Annie Cushing

    Fantastic resources! I’d love to see a blog post on how to use Tim Hall’s REST client.

  • http://www.annielytics.com/ Annie Cushing

    By the time you get to the end of this video, you will have an advanced understanding of how vlookups work: https://www.youtube.com/watch?v=-hJxIMBbmZY. It’s off-the-charts awesome.

  • http://www.annielytics.com/ Annie Cushing

    I used to be so intimidated by Excel, and my lack of comfort with it almost caused me to fail an analytics certification course I was taking. (That near brush with failure ended up becoming the impetus for my obsession with the program.) But I started with watching lynda.com tutorials. I think I paid $25/mo for maybe three months and consumed a lot of videos in that time. From there, I read books that focused on the areas I wanted to learn specifically – like charting, pivot tables, formulas, etc.

  • http://www.annielytics.com/ Annie Cushing

    I use this gdoc for SERP scraping: http://bit.ly/1anrz8R. Make a copy to save off your own copy and scrape away. Not sure this is what you had in mind, but it’s my fave scraper.

  • andrekibbe

    It was. Thanks for the link, and thanks for the article!

  • http://www.annielytics.com/ Annie Cushing

    You’re welcome!

  • Johny Woller Skovdal

    Nice article, and great resources to go for further reading.
    One of the most useful features I discovered recently was Array Formulas. Really helped me out in crunching data a lot quicker than before. :) http://office.microsoft.com/en-us/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx

  • http://www.annielytics.com/ Annie Cushing

    Oh? I only use them every once in a while. Can you give some examples of where you fit them into your workflow? You’ve piqued my curiosity.

  • SingleTrackGirl

    you’re my hero.

  • http://www.annielytics.com/ Annie Cushing

    That was easy. :)

  • SingleTrackGirl

    ;) now my work begins (learning). very excited. thank you.

  • http://www.annielytics.com/ Annie Cushing

    My pleasure! Run like the wind. :)

  • http://www.clinicaferrusbratos.com/ marconi88