- Format data in Excel and use formulas to gather insights
- Use tables to sort data and create pivot tables.
- Create your own metrics dashboard.
Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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.
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
5.0 rating, based on 1 Class Central review
Showing Class Central Sort
-
I recently had the pleasure of enrolling in the "Excel for Marketers" course offered by HubSpot Academy, and I am thrilled to share my exceptional experience. This course is an absolute gem for anyone in the marketing field looking to harness the po…