Excel for Marketers

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.

• 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