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

Advanced

5 modules · ~7h

Advanced Spreadsheets & Modeling

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

5 modules12 lessons~7h

Multi-sheet workbooksData modelingData quality auditingExecutive dashboardsProfessional reportingVLOOKUPINDEX + MATCH

Start course

Recommended prerequisites

Spreadsheets for Analysis

Content

Course modules

5 modules

Understanding Multi-sheet Data

Learn how to organize related data across multiple sheets.

Reading8m

Explore a Multi-sheet Workbook

Use COUNTIF to count employees per department across sheets.

Lab10m

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

Advanced

5 modules · ~7h

Advanced Spreadsheets & Modeling

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

5 modules12 lessons~7h

Multi-sheet workbooksData modelingData quality auditingExecutive dashboardsProfessional reportingVLOOKUPINDEX + MATCH

Start course

Recommended prerequisites

Spreadsheets for Analysis

Content

Course modules

5 modules

Understanding Multi-sheet Data

Learn how to organize related data across multiple sheets.

Reading8m

Explore a Multi-sheet Workbook

Use COUNTIF to count employees per department across sheets.

Lab10m

Advanced Spreadsheets & Modeling

Recommended prerequisites

Course modules

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

Course modules

Multi-sheet Thinking

Understanding Multi-sheet Data

Explore a Multi-sheet Workbook

Data Modeling Basics

Audit & Quality Checks

Executive Reporting

Lookup Functions