Learn Power Query for Excel and Power BI
Short lessons, then practice on messy fictional data in a browser workspace. 80 lessons and 418 graded exercises.
Topics
- How Power Query thinksSources, previews and applied steps: why every transformation is a repeatable recipe.
- Importing and inspecting dataCSV, table-like Excel sheets and JSON fixtures; headers, delimiters and encodings.
- Data types, locale and nullsTypes, culture-aware conversion of numbers and dates, and the difference between null, blank and error.
- Working with columnsChoose, remove, rename, reorder and duplicate columns, and keep queries stable when columns change.
- Filtering and sorting rowsFilter by value, combine conditions, sort on several keys and keep top or bottom rows.
- Text transformationsTrim, clean, change case, split, merge, extract and replace text with exact semantics.
- Numbers, dates and conditional columnsRounding, date parts, durations and conditional logic.
- Profiling, errors and validationFind and handle errors, missing fields and bad values with try … otherwise.
- Duplicates and keysRemove duplicates deliberately, choose the right row to keep and add index columns.
- Fill down and report layoutsFill down/up and turn report-style exports into tidy tables.
- Appending tablesStack tables, align schemas and handle mismatched columns.
- Merging (joining) tablesJoin kinds, composite keys, expanding results and predicting row counts.
- Group by and aggregationSummaries with sums, counts, averages and all-rows tables.
- Pivot and unpivotReshape wide and long tables and survive new columns on refresh.
- Combining files and parametersCombine folder-like file packs with one reusable transformation.
- M language basicsValues, let … in, records and lists.
- Functions, each and scopeeach, custom functions, branching and error handling in M.
- Nested data and JSONExpand records, lists and nested tables; flatten JSON.
- Refresh robustness and performance conceptsWriting queries that survive new data, and what query folding and privacy levels mean.
- Projects, debugging and interviewsIntegrated projects, debugging workflows and interview practice.