Free ebook
Free ebook: Pivot Tables from Zero
A complete beginner walkthrough for building your first PivotTable: rows, columns, values, and filters, grouping dates, changing how values summarize, slicers, sorting, and keeping it fresh when your data changes. Real practice data throughout.
Get the ebookCourse path
Turn Power Pivot & Data Model into a course path
Power Pivot & DAX strings this into a structured, advanced-friendly path with a full lesson list.
View course path4 subtopics in this path
Tables, relationships, measures, DAX basics, star schemas, model-driven pivots, and scalable reporting logic.
Each item pairs the learning structure with curated public YouTube resources where available, so learners can move from outline to video practice quickly.
Load tables into the model and understand why relationships beat giant flat tables.
excelisfun
Open on YouTube (opens in a new tab)
excelisfun
Open on YouTube (opens in a new tab)Connect lookup and fact tables, identify keys, and avoid many-to-many confusion.
excelisfun
Open on YouTube (opens in a new tab)Create measures for sums, counts, averages, percentages, and reusable calculations.
MyOnlineTrainingHub
Open on YouTube (opens in a new tab)
excelisfun
Open on YouTube (opens in a new tab)Compare periods, year-to-date totals, prior-year metrics, and rolling windows.
Real Excel screenshots showing what this topic looks like in practice.
Kevin Stratvert
Full tutorial covering relationships, calculations, measures, PivotTables, and slicers.
Open on YouTube (opens in a new tab)excelisfun
Direct match for Power Pivot, relationships, DAX measures, and filter context.
Open on YouTube (opens in a new tab)excelisfun
Long-form class video for deeper data-modeling and DAX practice.
Open on YouTube (opens in a new tab)excelisfun
Focused resource for moving from the Data Model into DAX formulas and functions.
Open on YouTube (opens in a new tab)
Maven Analytics
Compact overview of the modern Excel BI workflow from data prep to DAX.
Open on YouTube (opens in a new tab)MyOnlineTrainingHub
Focused lesson for learners who need to understand DAX measure authoring in Excel models.
Open on YouTube (opens in a new tab)
Chandoo
Example-driven format gives learners a structured path from simple to advanced DAX thinking.
Open on YouTube (opens in a new tab)
Chandoo
Measure-focused masterclass is valuable for learners moving into analytical reporting.
Open on YouTube (opens in a new tab)excelisfun
Full DAX class is a strong advanced resource for Excel data-model reporting skills.
Open on YouTube (opens in a new tab)
Ben Jones Explains
Beginner full tutorial aligned to Power Pivot, relationships, and DAX together.
Open on YouTube (opens in a new tab)26 places we cite for accuracy. We link to them; none has reviewed, endorsed, or collaborated on this site.
Official documentation
Educators and channels
ExcelJet (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)
Teacher's Tech (opens in a new tab)
YouTube (opens in a new tab)Course platforms
