All courses

Specialist · Automation

VBA & Macros

Turn hours of repetitive clicking into one button with recorded macros and your own VBA code.

New course(0 reviews) 10 modules · 64 lessons 11 knowledge checks About 2.5 hours of hands-on practice
View pricing

What you’ll learn

  • Record, run, edit and save macros safely
  • Write and debug VBA procedures in the VBA Editor using the Excel object model
  • Automate tasks with variables, ranges, conditions, loops and error handling
  • Build UserForms that add, look up and edit worksheet data

Course overview

If you repeat the same clicks every week, this course gives you that time back. You'll start by recording macros, then learn to read, edit and write your own VBA code one small step at a time: variables, ranges, conditions, loops and error handling.

Lessons run in the Academy's built-in Visual Basic Editor, so you watch a short demo and then write and run the code yourself straight away. By the end you'll build UserForms that add, look up and edit worksheet data, and a workbook that turns a half-day monthly report into one click.

How you’ll learn

Write real VBA in your browser

Watch a short guided demo, then write and run the code yourself in the built-in Visual Basic Editor on the same workbook.

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: Monthly Report Automator

Every month someone at Northstar spends half a day copying, formatting and emailing the same report. You'll build a macro-enabled workbook that does it in one click: it adds the new month's sheet, cleans and formats the data, builds the summary and offers a UserForm for entering new sales safely.

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

10 modules · 64 lessons · 11 knowledge checks
  • Interactive lesson
  • Step-by-step guide
  • Knowledge check

Where this course fits

A specialist course you can take any time after the recommended core level.

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

Before you start

Level 3: Intermediate Lookups & Data Summaries. Level 5's 'A Taste of VBA' module is a helpful head start. Requires desktop Excel for Windows or Mac.

Who this course is for

  • Anyone who repeats the same Excel task every week or month
  • Confident Excel users who are curious about code (no programming experience needed)
  • People who want simple, safe forms for data entry

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