course
Power Pivot, Power Query and DAX in Excel
Simon Sez IT
Updated Jul 03, 2025
What you'll learn
- Transform and clean data using Power Query
- Create and manage data models with Power Pivot
- Perform advanced calculations using DAX formulas
- Visualize data insights with PivotTables and PivotCharts
Course Description
In this advanced-level course, you will explore three crucial features in Excel: Power Pivot, Power Query and DAX. This suite of functions allows you to manipulate, analyze and evaluate millions of rows of data from Excel or other databases. If you've reached a point where you need Excel to work with data at scale, then these tools will unlock that capability.
Upon completion of this course, you will know how to bring your data together, then merge and clean it using Power Query. As you proceed to creating relationships between data tables and building out a data model, you will then be able to perform calculations using DAX, and finally display your analysis using PivotTables and PivotCharts.
