Microsoft Excel Advanced
Course Overview
Curriculum Structure
Comprehensive modules designed for real-world impact
Power Query Fundamentals
Import data from multiple sources, clean and transform data
Advanced Power Query Transformations
Merge queries, append queries, unpivot, group by, custom columns (M language basics)
Power Pivot and Data Modeling
Understand Data Models, create relationships, and manage tables
Data Model Relationships & DAX Basics
Build star schema, write basic DAX measures (SUMX, CALCULATE, etc.)
Advanced Logical & Analytical Formulas
Master nested IFs, IFS, SWITCH, LET, LAMBDA (intro), array formulas
What-If Analysis & Scenario Manager
Use Goal Seek, Data Tables, Scenario Manager, and Solver
Interactive Dashboard Building
Design professional dashboards with slicers, timelines, charts, and interactivity
Performance Optimization & Best Practices
Optimize large files, reduce calculation time, file size reduction, best practices
Available Bootcamps
Choose a cohort and begin your journey to becoming job-ready