Welcome: what you will learn and how the course works
Start Here · 4 min
Welcome to Excel + AI Mastery. This short introduction walks you through the course: nine modules, more than 50 video lessons and 100+ essential Excel functions, all practised on realistic business data from Harbor Office Supply, a fictional US company.
How the course is organized
- Modules 1-4: formula foundations, text cleanup and lookups, analysis and finance, and four real business projects.
- Modules 5-7: masterclasses on lookups, dynamic arrays and the power functions you still need (GROUPBY, PIVOTBY, LAMBDA helpers, REGEX and more).
- Module 8: Excel + AI workflows - prompts that produce correct formulas, test grids, and AI for inherited workbooks.
- Module 9: nine real-world use cases, from attendance tracking and receivables aging to a formula-only KPI dashboard, plus the final capstone.
How each lesson works
- Watch the video and pause whenever you are asked to predict a result.
- Download the lesson's Practice Pack from the Practice resources tab: a practice workbook with blank formula cells, a Checks sheet that marks your answers, and the completed solution.
- Finish the Your Turn challenges before moving on.
Assessments and certificate
Every module ends with a hands-on assessment workbook, a 10-question quiz (pass mark 70%) and a full solution walkthrough video. Complete every lesson and pass every quiz to unlock your certificate.
What you need
Microsoft 365 Excel for Windows is recommended. Excel 2021/2024 handle most lessons; each lesson lists its Excel version and older-version alternatives. AI steps are optional, and every AI answer in the course is checked by hand, so no paid AI subscription is needed.
Practice resources
FREE EXCEL LESSONS BY EMAIL
Not ready to enroll yet?
Join the Academy email list for practical Excel and AI tips, free preview lessons and news when a new course opens. Unsubscribe at any time.
