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

1

Understanding Multi-sheet Data

Learn how to organize related data across multiple sheets.

2

Explore a Multi-sheet Workbook

Use COUNTIF to count employees per department across sheets.