<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=893596480692132&amp;ev=PageView&amp;noscript=1">
HubSpot_logo

HubSpot is an inbound marketing and sales software platform that helps companies attract visitors, convert leads and close customers.

How-to-Use-Excel-cover-on-book.png

How to Use Excel

Essential Training for Data-Driven Marketing

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.

In this guide, you'll learn:

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

Frequently Asked Questions

Why do I need to fill out the information requested?

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.

Is this really free?

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

Master Excel Today