Productivity & Data · Beginner → Expert
📗 Microsoft Excel: Beginner to Expert
Master spreadsheets from formulas and tables through Power Query, PivotTables, dynamic arrays, dashboards, modeling, automation, data quality and auditability.
Course roadmap
Pass each module exam to unlock the next module.
Module 1 · Beginner
Workbook Fundamentals, References and Data Entry
Locked
Module 2 · Beginner
Core Formulas, Functions and Error Handling
Locked
Module 3 · Beginner
Tables, Structured References and Named Ranges
Locked
Module 4 · Beginner
Lookup and Reference Functions
Locked
Module 5 · Intermediate
Dynamic Arrays and Modern Formula Design
Locked
Module 6 · Intermediate
Text, Date, Time and Logical Functions
Locked
Module 7 · Intermediate
Data Validation, Cleaning and Conditional Formatting
Locked
Module 8 · Intermediate
Charts and Data Visualization
Locked
Module 9 · Advanced
PivotTables, PivotCharts and Slicers
Locked
Module 10 · Advanced
Power Query and Repeatable Data Transformation
Locked
Module 11 · Advanced
Data Model, Power Pivot and DAX Foundations
Locked
Module 12 · Advanced
Scenario Analysis, Goal Seek and Solver
Locked
Module 13 · Advanced
Financial and Business Modeling Practices
Locked
Module 14 · Expert
Automation with Office Scripts and VBA Concepts
Locked
Module 15 · Expert
Workbook Performance, Protection and Auditing
Locked
Module 16 · Expert
Collaboration, Sharing and Version Control Practices
Locked
Module 17 · Expert
Expert Capstone: Auditable Business Analysis Workbook
Locked
Certification gate
Final course exam
Pass mark: 80%. Time limit: 360 minutes. All module exams must be passed first.
Locked until modules are passed