AI · Automation
AI for Excel: Advanced Automation, VBA & Modeling
Brief AI like a senior analyst: LAMBDA functions, VBA macros, Power Query M code and financial models, each one tested before you trust it.
What you’ll learn
- Prompt for dynamic arrays, LET and LAMBDA functions, and verify every variable and rule
- Turn AI-written VBA into macros that run safely, and debug them when they don't
- Use AI for Power Query M code without case, null or hard-coding mistakes
- Scaffold, stress-test and prove financial models built with AI's help
Course overview
Once you're comfortable checking AI's formulas, it can take on much bigger jobs: dynamic-array reports, reusable LAMBDA functions, VBA macros, Power Query M code and financial models. This course shows you how to brief it like a senior analyst, with sheet names, ranges, edge cases and constraints, so the first draft is close and the fixes are quick.
You'll paste AI-written code into the Academy's built-in Visual Basic Editor and Power Query editor, find the line that's wrong and fix it, balance a model it scaffolded, and stress-test your work with synthetic data and edge cases. The final project combines all of it into one refreshable operations report.
How you’ll learn
Paste it, run it, fix it
Each lesson pairs a real prompt and AI reply with a live workbook, Visual Basic Editor or Power Query editor, so you test the AI's work exactly where it runs. No AI subscription needed.
Graded on the result, not the prompt
“Check my work” grades the finished workbook, code and queries, so you're marked on whether it works.
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: Autonomous Operations Report
Northstar's operations team wants a report that rebuilds itself. You'll fix an AI-written Power Query that combines the branch exports, build a branch summary with dynamic arrays and LET, and finish with an AI-drafted macro that sets up the page and exports the PDF.
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
7 modules · 30 lessons · 6 knowledge checks- Interactive lesson
- Step-by-step guide
- Knowledge check
Where this course fits
Part of the AI path. AI writes the formulas faster, but you still need to know whether they're right, so take it after the recommended core level.
- Level 1Excel Foundations
- Level 2Essential Formulas & Everyday Logic
- Level 3Intermediate Lookups & Data Summaries
- Level 4Advanced Dynamic Arrays & LogicRecommended first
- Level 5Expert Techniques & Workbook Architecture
Before you start
AI for Excel: Everyday Productivity & Formulas, plus Level 4 (or comfortable with dynamic arrays). The VBA & Macros and Power Query courses help but aren't required.
Who this course is for
- Confident Excel users ready to hand bigger jobs to AI
- Analysts who want macros and M code without memorising the syntax
- Learners who have finished the first AI course and Level 4 (or similar experience)
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!”