Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Excel for Marketers

via Hubspot Academy

Overview

As a marketer, you are likely using multiple systems to manage your data, including Google Analytics and a CRM. Analyzing data across disparate systems can be a challenge. That's where Excel comes in. In this course, you'll learn how to import your data into Excel and use functions, the value of tables and how to use them, how to create your own metrics dashboard, and how to automatically update your data regularly.
  • Format data in Excel and use formulas to gather insights
  • Use tables to sort data and create pivot tables.
  • Create your own metrics dashboard.

Syllabus

  • Working With Data in Excel
    • In this lesson, you will learn how to import data into Excel and use formulas.
  • Analyzing Data in Excel
    • In this lesson, you will learn the value of tables and how to work with table’s functionality.
  • Visualizing Data in Excel
    • In this lesson, you will learn how to create your own metrics dashboard in Excel.
  • Automating the Process
    • In this lesson, you will learn how to update your dashboard and perform regular edits by copying a file to a folder.
  • Excel for Marketers Course Next Steps
    • Excel for Marketers Course Next Steps

Reviews

Start your review of Excel for Marketers

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.