Workplace Excel automation
Clear VBA for the Excel work you do every day.
Structured free lessons for finance, operations, and reporting teams. Learn VBA the practical way: macros you can use on real spreadsheets, not toy examples.
Choose your track
Beginner, Intermediate, and Advanced paths are free. Work through them in order or jump to the topics you need.
Beginner
Beginner track
Open the VBE, write your first macros, and automate simple worksheet tasks.
8 lessons
Intermediate
Intermediate track
Handle data with arrays and dictionaries, add error handling, and build reusable tools.
7 lessons
Advanced
Advanced track
Design class modules, event-driven workflows, and performant automation apps.
5 lessons
Start here
One flagship lesson from each track.
-
Advanced
Class Modules for Maintainable Tools
Model report rows and validators as classes instead of scattered public variables.
-
Beginner
Your First Workplace Macro
Build a macro that validates a report tab and writes a summary status column.
-
Intermediate
Error Handling That Survives Production
Use On Error GoTo, clean up objects, and leave workbooks in a safe state.
Latest articles
Deep dives on specific VBA topics.
Paid course
Workplace VBA Projects
Build five real-world Excel automation projects—validation tool, export pipeline, dashboard updater, reconciliation helper, and handoff-ready workbook.
$249 USD
Replace placeholderUrl with your Lemon Squeezy or Gumroad checkout link.