Excel & Google Sheets for Marketing Analytics

Description

For marketers who work with exported data every day and want to stop fighting messy spreadsheets — whether or not you plan to go on to SQL, Python or BI tools.

Timeline: 3 Weeks (Part-Time)
Prerequisite: None
Outcome: Spreadsheet Analytics Competency

Key Topics Covered:

• Formulas & Functions (SUMIFS, COUNTIFS)
• Lookups (VLOOKUP, XLOOKUP) & Cleaning Messy Exports
• Building Pivot Tables From Scratch
• Grouping, Summarising and Filtering With Pivot Tables
• Interactive Pivot Tables With Slicers
• Charts & Conditional Formatting for At-a-Glance Reporting

What You Gain:

• Ability to build SUMIFS/COUNTIFS formulas and lookups instead of manually filtering data.
• Skills to build and refresh pivot tables and interactive slicers for fast reporting.
• A finished report combining formulas, pivot tables, charts and conditional formatting.