Microsoft Excel Essentials
Build a solid, reliable foundation in Excel: structure, formulas, formatting and the habits that prevent broken spreadsheets.
Nine structured courses, 56 hours of video and 363 lessons, covering the complete path from spreadsheet fundamentals to published business intelligence. Each course page lists the level, prerequisites, full module breakdown and learning outcomes before you buy anything.
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.
Stop cleaning the same file every month. Build repeatable transformations that refresh with one click.
Relationships, star schemas and DAX measures — the data model behind every serious Excel report.
From raw data to a published, refreshing report that stakeholders actually open.
The concepts behind the tools: KPIs that mean something, metric definitions, and reporting that drives decisions.
Layout, colour, chart choice and hierarchy — how to build a dashboard people read instead of ignore.
Use AI assistants for analysis, documentation and drafting — with the verification habits that keep you safe.
Macros, VBA fundamentals and Office Scripts — automating the repetitive work that eats your week.
Courses can be taken in any order, but this is the progression we would recommend to someone starting from scratch and working through the whole catalogue.
| # | Course | Level | Assumes you have | Hours |
|---|---|---|---|---|
| 1 | Microsoft Excel Essentials | Beginner | No prior experience | 6 |
| 2 | Advanced Excel | Intermediate | Essentials, or equivalent daily use | 8 |
| 3 | Power Query | Intermediate | Comfort with tables and formulas | 6 |
| 4 | Power Pivot & Data Modelling | Advanced | Power Query | 7 |
| 5 | Business Intelligence Foundations | All levels | Nothing — can be taken first | 5 |
| 6 | Dashboard Design | Intermediate | BI Foundations recommended | 5 |
| 7 | Power BI | Intermediate → Advanced | Power Query; Power Pivot recommended | 9 |
| 8 | Automation with Excel | Advanced | Advanced Excel | 6 |
| 9 | AI for Productivity | All levels | Nothing — standalone | 4 |
Single courses from €30, or the full catalogue with lifetime access for €65.