How to Use Excel

Make more informed marketing decisions in less time

• Ever find yourself up to your elbows in an Excel worksheet with seemingly no end in sight? You’re manually replicating columns and scribbling down long-form math on a scrap of paper, all while thinking to yourself, “There has to be a better way to do this.” Truth be told, there probably is … you just don’t know it yet.
• To truly be a data-driven marketer, you’ll need a bit more Excel knowledge than a simple SUM formula. Here’s where this guide comes in. Whether you’d like to speed up your chart formatting, finally understand pivot tables, or complete a VLOOKUP, we’ll teach you everything you need to know.
• At the start of each topic, you’ll find a short video to dip your toe in the water -- a perfect solution for those pressed for time and in search of a quick answer. Next, the deep dive. Read along for a few extra functions and reporting insight. Finally, for those who learn best by doing, we’ve included Test Your Skills questions at the close of each chapter.

• Tweet