These days, everyone and their mother has “Microsoft Excel” listed as one of their skills on LinkedIn. So you probably already know that Excel is a powerful tool for data analysis, manipulation, and visualization. Working in Marketing Analytics, I literally use Excel every single day. (In fact, you might have noticed that I’ve been AWOL on the blog recently — I’ve been so busy with work that all I can even think about is Excel.) Some people are “Excel Wizards”, using tons of shortcuts and fancy formulae. If that’s you, more power to you! But in the end, it’s the output that matters: how will you communicate your work to an audience of colleagues or clients? Often you’ll present your findings in a series of charts or graphs. And when I see a professional slide deck full of ugly, unpolished, or even default-style Excel bar graphs (or any graphs), it drives me up the wall.
I want to help you. Continue reading