← Course overviewExcel VBA Basics with AI: From Your First Macro to Real Automation
MODULE 1 / 12LESSON 1 OF 82
Welcome: what you will automate and how AI fits in
Start Here · 3 min
The business scenario
Pine Valley Office Supply in Columbus, OH exports its orders every month. The October export has 273 rows with blank rows, duplicates, text amounts and messy names. Cleaning it by hand takes the sales team about two hours. At the end of this course your own macro turns it into 260 clean orders worth $233,068.13 with one click.
What you will be able to do
Know what you will build in this course, how the modules, AI Corners, assessments and quizzes fit together, and how to get the most out of each lesson.
In this video
- Meet Pine Valley Office Supply
- The finish line: the monthly report cleaner
- 11 modules, one skill at a time
- The AI Corner
- Assessments and quizzes
- How to study
Practice resources
Module-00-Start-Here-Practice-Files.zip9 KB
Enroll to downloadModule-01-Macros-and-Recorder-Practice-Files.zip141 KB
Enroll to downloadModule-01-Macros-and-Recorder-Solutions.zip137 KB
Enroll to downloadModule-02-VBA-Editor-Practice-Files.zip130 KB
Enroll to downloadModule-02-VBA-Editor-Solutions.zip137 KB
Enroll to downloadModule-03-Excel-Objects-Practice-Files.zip240 KB
Enroll to downloadModule-03-Excel-Objects-Solutions.zip251 KB
Enroll to downloadModule-04-Variables-Practice-Files.zip152 KB
Enroll to downloadModule-04-Variables-Solutions.zip162 KB
Enroll to downloadModule-05-Decisions-Practice-Files.zip106 KB
Enroll to downloadModule-05-Decisions-Solutions.zip111 KB
Enroll to downloadModule-06-Loops-Practice-Files.zip263 KB
Enroll to downloadModule-06-Loops-Solutions.zip274 KB
Enroll to downloadModule-07-User-Interaction-Practice-Files.zip186 KB
Enroll to downloadModule-07-User-Interaction-Solutions.zip205 KB
Enroll to downloadModule-08-Sheets-and-Workbooks-Practice-Files.zip312 KB
Enroll to downloadModule-08-Sheets-and-Workbooks-Solutions.zip263 KB
Enroll to downloadModule-09-Debugging-Practice-Files.zip209 KB
Enroll to downloadModule-09-Debugging-Solutions.zip196 KB
Enroll to downloadModule-10-AI-Tutor-Practice-Files.zip185 KB
Enroll to downloadModule-10-AI-Tutor-Solutions.zip145 KB
Enroll to downloadModule-11-Capstone-Practice-Files.zip106 KB
Enroll to downloadModule-11-Capstone-Solutions.zip46 KB
Enroll to downloadStart-Here-Cheat-Sheet-Roadmap-and-AI-Prompt-Library.zip25 KB
Enroll to downloadCourse-Data.zip154 KB
Enroll to downloadFREE EXCEL LESSONS BY EMAIL
Not ready to enroll yet?
Join the Academy email list for practical Excel and AI tips, free preview lessons and news when a new course opens. Unsubscribe at any time.