Advanced Spreadsheets & Modeling

Master multi-sheet data, data modeling, lookup functions, quality auditing, and executive reporting.

Modules

Lessons

Exercises

~7h

Duration

Multi-sheet workbooksData modelingData quality auditingExecutive dashboardsProfessional reportingVLOOKUPINDEX + MATCH

Start Course

Recommended Prerequisites

Spreadsheets for Analysis

Understanding Multi-sheet Data

Learn how to organize related data across multiple sheets.

08m

Explore a Multi-sheet Workbook

Use COUNTIF to count employees per department across sheets.

010m

Tracks/Spreadsheets (Excel/Google Sheets)/Advanced Spreadsheets & Modeling

Advanced

Advanced Spreadsheets & Modeling

Master multi-sheet data, data modeling, lookup functions, quality auditing, and executive reporting.

Modules

Lessons

Exercises

~7h

Duration

Multi-sheet workbooksData modelingData quality auditingExecutive dashboardsProfessional reportingVLOOKUPINDEX + MATCH

Start Course

Recommended Prerequisites

Spreadsheets for Analysis

Understanding Multi-sheet Data

Learn how to organize related data across multiple sheets.

08m

Explore a Multi-sheet Workbook

Use COUNTIF to count employees per department across sheets.

010m

Advanced Spreadsheets & Modeling

Recommended Prerequisites

Multi-sheet Thinking

Understanding Multi-sheet Data

Explore a Multi-sheet Workbook

Data Modeling Basics

Audit & Quality Checks

Executive Reporting

Lookup Functions

Advanced Spreadsheets & Modeling

Recommended Prerequisites

Multi-sheet Thinking

Understanding Multi-sheet Data

Explore a Multi-sheet Workbook

Data Modeling Basics

Audit & Quality Checks

Executive Reporting

Lookup Functions