Free ebook
Free ebook: Conditional Formatting Mastery
Everything you need to know about Excel's conditional formatting: highlight rules, top/bottom rules, data bars, color scales, icon sets, formula-based rules, managing and debugging rules, and real-world use cases. Hands-on examples throughout.
Get the ebookFree tools
Practice with free browser tools
Formula builder, formula explainer, CSV cleaner, and 7 more — no upload, no sign-up. Try what you learn in the lessons.
Browse free tools=COURSE.PATH
Power Pivot & DAX
Courses for Power Pivot, the Data Model, relationships, DAX measures, filter context, and model-driven reporting.
What this path is for
Use this page when you want a guided route through public Excel lessons without searching from scratch. Preview a tutor, open the full lesson on YouTube, and return here for the next option.
Learn
Load tables into the Data Model and define relationships.
Learn
Create reusable DAX measures for model-driven reporting.
Learn
Understand filter context and analytical model structure.
Suggested course flow
- 01How to use Power Pivot in Excel | Full TutorialKevin Stratvert - preview available
- 02MS 365 Excel Basics 11: Power Pivot, Data Model, Relationships & DAX Measures, & Filter Context Too!excelisfun - preview available
- 03Excel Data Analysis Class 02: Power Pivot, DAX Formulas, Relationships, Data Modeling & Much More!excelisfun - preview available
- 04MSPTDA 15: Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX Functionsexcelisfun - preview available
- 05Use Excel Like a PRO | Learn Power Query, Power Pivot & DAX in 15 MinutesMaven Analytics - preview available
- 06How and where to write DAX Measures for Power BI and ExcelMyOnlineTrainingHub - preview available
Previewable lessons
01
02
MS 365 Excel Basics 11: Power Pivot, Data Model, Relationships & DAX Measures, & Filter Context Too!
excelisfun
Open on YouTube (opens in a new tab)03
Excel Data Analysis Class 02: Power Pivot, DAX Formulas, Relationships, Data Modeling & Much More!
excelisfun
Open on YouTube (opens in a new tab)04
MSPTDA 15: Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX Functions
excelisfun
Open on YouTube (opens in a new tab)05
Use Excel Like a PRO | Learn Power Query, Power Pivot & DAX in 15 Minutes
Maven Analytics
Open on YouTube (opens in a new tab)06
How and where to write DAX Measures for Power BI and Excel
MyOnlineTrainingHub
Open on YouTube (opens in a new tab)07
08
Getting started with Power Pivot & DAX - 15 Useful Measures
Chandoo
Open on YouTube (opens in a new tab)09
Full Free DAX Class: Fundamentals of DAX in Power BI & Power Pivot
excelisfun
Open on YouTube (opens in a new tab)10
Sources we reference — not partners
26 places we cite for accuracy. We link to them; none has reviewed, endorsed, or collaborated on this site.
Official documentation
Educators and channels
- Chandoo (opens in a new tab)
ExcelJet (opens in a new tab)- MrExcel (opens in a new tab)
- Contextures (opens in a new tab)
MyOnlineTrainingHub (opens in a new tab)
XelPlus (opens in a new tab)
Excel Campus (opens in a new tab)
Wise Owl (opens in a new tab)- Simon Sez IT (opens in a new tab)
Teacher's Tech (opens in a new tab)
YouTube (opens in a new tab)- Edureka (opens in a new tab)
Course platforms
