All courses

AI · Productivity

AI for Excel: Everyday Productivity & Formulas

Use Copilot or any chat AI to write, explain and fix everyday formulas, and learn to catch its mistakes before your manager does.

New course(0 reviews) 7 modules · 35 lessons 6 knowledge checks About 2.5 hours of hands-on practice
View pricing

What you’ll learn

  • Write structured prompts that describe your sheet so AI gets formulas right first time
  • Keep personal and confidential data out of public AI tools
  • Prompt for, test and fix SUMIFS, IFS, XLOOKUP, date, text and conditional formatting formulas
  • Diagnose spill, reference, type and silent logic errors in AI-written formulas

Course overview

AI can write an Excel formula in seconds, but it can also hand you one that looks right and quietly gives the wrong answer. This course teaches you to use Copilot or any chat AI the way a careful analyst would: describe your sheet clearly, keep private data private, then test every formula before it goes anywhere near a report.

You'll prompt for the formulas people use every day (SUMIFS, IFS, XLOOKUP, date and text functions, conditional formatting rules) and practise the same skill in sales, HR, finance and operations sheets. Then the diagnostic clinics train you to spot spill errors, text numbers, boundary mistakes and made-up functions, so you catch AI's mistakes before your manager does.

How you’ll learn

Read the AI's answer, then prove it

Every lesson shows a real prompt and the AI's reply beside a live spreadsheet. A short demo shows what to check, then you test, fix and apply it yourself. No AI subscription needed.

Graded on the result, not the prompt

“Check my work” grades the finished sheet, so you're marked on the answer being right, however you got there.

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: Regional Performance Report

Northstar's sales director needs revenue by region from a messy order export. Using a colleague's AI chat, you'll test every reply, fix the ones that are wrong, and build a clean report with lookups, regional totals and a big-order highlight.

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 · 35 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.

  1. Level 1Excel Foundations
  2. Level 2Essential Formulas & Everyday LogicRecommended first
  3. Level 3Intermediate Lookups & Data Summaries
  4. Level 4Advanced Dynamic Arrays & Logic
  5. Level 5Expert Techniques & Workbook Architecture

Before you start

Levels 1 and 2: Excel Foundations and Essential Formulas & Everyday Logic (or comfortable with basic formulas and cell references).

Who this course is for

  • Everyday Excel users who want AI to save them time without risking wrong numbers
  • People whose company has rolled out Copilot, ChatGPT or a similar assistant
  • Learners who have finished Levels 1 and 2 (or know the basics)

Meet your instructor

Kyle Stott

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.”
MarioMicrosoft Excel – Overview · April 21, 2023
“Really enjoyed this course! Packed full of useful insights. Even though I consider myself somewhat experience with Excel, I still took away new learnings.”
JackMicrosoft Excel – Overview · April 14, 2023
“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!”
AleksandraMicrosoft Excel – Overview · April 13, 2023