Welcome: what you will learn and how the course works

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.