VBA Basics
Open the editor, write your first working macro, and understand every line of it.
Catalog
Excel VBA courses
Every course ends with a final exam and a verifiable certificate. The first lesson is always free.
Excel VBA
Automate Excel with macros: from your first Sub to classes, APIs and reporting.
Ranges & Cells
Point your code at exactly the right cells and read or write them without ever clicking.
Logic & Loops
Make your macros decide for themselves and repeat work across thousands of rows.
Macro Recorder & Cleanup
Record what Excel does, read the code it produces, and rewrite it into something fast and reliable.
Worksheets & Workbooks
Point your code at the right sheet and the right file, every single time.
Errors & Debugging
Find out what your macro is really doing, and fail gracefully when something goes wrong.
UserForms
Build proper data-entry windows so people stop typing straight into your spreadsheet.
Automation & Reports
Let Excel react on its own, gather data from a folder, and send the finished report out the door.
Arrays & Performance
Pull a whole range into memory, do the work there, and write it back in a single line — hundreds of times faster.
Collections & Dictionary
Group, count and de-duplicate thousands of rows in one pass using keys instead of nested loops.
Text & Strings
Cut, search, split, join and reshape messy text until it looks like clean data.
Dates & Times
Build, compare, shift and format dates reliably — including the text ones that arrived from somebody else's system.
Custom Functions (UDF)
Write your own worksheet functions in VBA and use them in cells just like SUM or VLOOKUP.
PivotTables with VBA
Build, fill, filter and refresh PivotTables entirely in code, so a monthly report becomes one click.
Charts with VBA
Create, format and export Excel charts from code so every report looks identical every month.
Excel Tables (ListObjects)
Stop guessing where your data ends — drive real Excel Tables from VBA and let them resize themselves.
Files, Folders & CSV
Let your macros walk through folders, read and write text files, and swallow a hundred CSV exports into one sheet.
External Data with SQL (ADO)
Pull exactly the rows you need out of closed workbooks, Access files and SQL Server — without opening a thing.
Web, APIs & JSON
Call a web service from a macro, survive the things that go wrong, and get the answer onto a sheet.
Class Modules & Structure
Build your own objects, then use them to turn a thousand-line macro into something you can still read next year.