Level 5
Expert Techniques & Workbook Architecture
Build bulletproof, professional models with modern functions, error handling, and formula auditing.
What you’ll learn
- Structure workbooks into clear inputs, calculations and outputs
- Audit formulas with tracing, Evaluate Formula and the Watch Window
- Simplify formulas with LET and build reusable custom functions with LAMBDA
- Summarise data with PivotTables, slicers, timelines and PivotCharts
- Protect, share and speed up workbooks other people can trust
Course overview
The final core level is about building workbooks other people can trust, understand and maintain. You'll learn how professionals separate inputs, calculations and outputs, and how to audit any formula with tracing, Evaluate Formula and the Watch Window.
You'll simplify complex formulas with LET, create your own reusable functions with LAMBDA, master PivotTables with slicers, timelines and PivotCharts, and learn to protect, share and speed up your work, with a first taste of VBA to finish the core track.
How you’ll learn
Watch, then do it yourself
Short guided demos narrated by Kyle, then you repeat each step on the same live spreadsheet, right in your browser.
Instant feedback
“Check my work” grades your sheet the moment you finish, and knowledge checks every few lessons lock it in.
Help when you're stuck
Owl, your AI tutor, sees exactly what's on your sheet. Members can also message Kyle directly through 'Ask Kyle'.
Your course project
Northstar Solutions: Annual Performance Model
Northstar's leadership is ready for a real annual performance model. You'll design it like a professional: separate Inputs, Calculations and Outputs, audited formulas, LET and custom LAMBDA functions, PivotTables with connected slicers and timelines, protection for the right cells and a quick macro button — the capstone of the core track.
Every course in the academy works with the same company, so each project builds on the skills, and the data, from the last.
Course content
8 modules · 61 lessons · 12 knowledge checks- Interactive lesson
- Step-by-step guide
- Knowledge check
Where this course fits
Level 5 of the five-level core track. Each level builds on the one before it.
- Level 1Excel Foundations
- Level 2Essential Formulas & Everyday Logic
- Level 3Intermediate Lookups & Data Summaries
- Level 4Advanced Dynamic Arrays & Logic
- Level 5Expert Techniques & Workbook ArchitectureYou are here
Before you start
Level 4: Advanced Dynamic Arrays & Logic, or comfort with FILTER, INDEX/MATCH and what-if analysis.
Who this course is for
- Experienced users who build workbooks for other people
- Anyone responsible for models that must be accurate and easy to maintain
- Learners completing the core track
Meet your instructor

Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade, consulting on and teaching best practices to over 400 companies across 30+ countries.
He built My Excel Academy so learners can practice in the same window they are learning in, with instant checks alongside an AI tutor, all while offering 1-on-1 instructor support when something doesn't add up.
Student reviews New course
This course doesn’t have reviews yet. Here’s what students say about the academy — rated 5.0 out of 5 across 3 reviews.
“My experience with My Excel Academy was excellent! The instructor was knowledgeable, engaging and provided plenty of hands-on practice. The course was perfect for beginners as it clearly outlined the workspace as well as some basic features that excel has to offer. I highly recommend this course for anyone looking to improve their excel skills or to begin their journey of learning excel.”
“Really enjoyed this course! Packed full of useful insights. Even though I consider myself somewhat experience with Excel, I still took away new learnings.”
“I really appreciate the refresher of key basics. I use Excel daily and learned new tools, lingo and strategies. It’s tempting to skip past these foundational elements to tackle the sticky and more complex problems. With these basics in hand I’ll have a much easier time navigating the system and bringing efficiency to my work! Time to customize my Quick Access Toolbar!”