Microsoft Excel Essentials
Build a solid, reliable foundation in Excel: structure, formulas, formatting and the habits that prevent broken spreadsheets.
Stop cleaning the same file every month. Build repeatable transformations that refresh with one click.
Power Query is the answer to the most expensive habit in office work: manually cleaning the same export, the same way, every single month. You build the transformation once, and from then on refreshing takes one click. For most professionals it is the single largest time saving available inside Excel.
8 modules · 38 lessons · approximately 6 hours of video
The manual clean-up loop, and what a repeatable pipeline replaces. Where queries live and how refresh works.
Files, folders, workbooks, databases and web pages. Relative paths and parameters so the file works on someone else's machine.
Removing columns and rows, promoting headers, changing types, splitting columns and filling down.
Turning a cross-tab report into tabular data — the transformation that makes everything downstream possible.
Append versus merge. Join kinds explained properly, with the join that silently duplicates your rows.
Combining every file in a folder, handling a new month's file automatically, and dealing with inconsistent headers.
Error rows, changed source columns, data type drift, and how to make a query fail loudly rather than silently.
Reading the generated code, editing a step by hand, custom columns, and simple parameters.
Build a solid, reliable foundation in Excel: structure, formulas, formatting and the habits that prevent broken spreadsheets.
Dynamic arrays, advanced lookups, financial and statistical functions, and models that are built to be audited.
Relationships, star schemas and DAX measures — the data model behind every serious Excel report.