How to Use Excel: An Essential Training for Data-Driven Marketers

Free Resource

excel book

Sharpen your data analysis skills with these tutorials.

Access Now for Free

In this guide, you'll learn:

  • Essential Functions
  • VLOOKUP
  • INDEX MATCH
  • IF Functions
  • Pivot Tables
  • Data Visualization
  • Conditional Formatting
  • and much more!

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.

Frequently Asked Questions (FAQs)

  • We will always keep your personal information safe.

    We ask for your information in exchange for a valuable resource in order to (a) improve your browsing experience by personalizing the HubSpot site to your needs; (b) send information to you that we think may be of interest to you by email or other means; (c) send you marketing communications that we think may be of value to you. You can read more about our privacy policy here.

  • Absolutely!

    Just sharing some free knowledge that we hope you’ll find useful. Keep us in mind next time you have marketing questions!

Learn Excel with step-by-step instructions, videos, and test questions.
Master Excel Today