Excel VBAVBA Basics
Open the editor, write your first working macro, and understand every line of it.
BeginnerCertificate$9.99
Excel VBA
Automate Excel with VBA
If you repeat the same steps in Excel every week, a macro can do them for you in seconds. The VBA track teaches you to write that code with confidence: what each line does, how to work with ranges and sheets, and how to keep a macro running reliably when the data changes. Explanations are short and every topic comes with exercises and knowledge checks.
The 20 courses start with the editor, ranges and loops, then move through the macro recorder, workbooks, error handling, UserForms, strings and dates, custom functions, charts, tables and file handling. The advanced part covers arrays and performance, dictionaries and collections, PivotTables in code, SQL with ADO, web requests with JSON and class modules.
Courses in Excel VBA
Excel VBA
Excel VBARanges & Cells
Point your code at exactly the right cells and read or write them without ever clicking.
BeginnerCertificate$9.99
Excel VBALogic & Loops
Make your macros decide for themselves and repeat work across thousands of rows.
BeginnerCertificate$9.99
Excel VBAMacro Recorder & Cleanup
Record what Excel does, read the code it produces, and rewrite it into something fast and reliable.
BeginnerCertificate$9.99
Excel VBAWorksheets & Workbooks
Point your code at the right sheet and the right file, every single time.
IntermediateCertificate$9.99
Excel VBAErrors & Debugging
Find out what your macro is really doing, and fail gracefully when something goes wrong.
IntermediateCertificate$9.99
Excel VBAUserForms
Build proper data-entry windows so people stop typing straight into your spreadsheet.
IntermediateCertificate$9.99
Excel VBAAutomation & Reports
Let Excel react on its own, gather data from a folder, and send the finished report out the door.
IntermediateCertificate$9.99
Excel VBAArrays & Performance
Pull a whole range into memory, do the work there, and write it back in a single line — hundreds of times faster.
AdvancedCertificate$9.99
Excel VBACollections & Dictionary
Group, count and de-duplicate thousands of rows in one pass using keys instead of nested loops.
AdvancedCertificate$9.99
Excel VBAText & Strings
Cut, search, split, join and reshape messy text until it looks like clean data.
IntermediateCertificate$9.99
Excel VBADates & Times
Build, compare, shift and format dates reliably — including the text ones that arrived from somebody else's system.
IntermediateCertificate$9.99
Excel VBACustom Functions (UDF)
Write your own worksheet functions in VBA and use them in cells just like SUM or VLOOKUP.
IntermediateCertificate$9.99
Excel VBAPivotTables with VBA
Build, fill, filter and refresh PivotTables entirely in code, so a monthly report becomes one click.
AdvancedCertificate$9.99
Excel VBACharts with VBA
Create, format and export Excel charts from code so every report looks identical every month.
IntermediateCertificate$9.99
Excel VBAExcel Tables (ListObjects)
Stop guessing where your data ends — drive real Excel Tables from VBA and let them resize themselves.
IntermediateCertificate$9.99
Excel VBAFiles, Folders & CSV
Let your macros walk through folders, read and write text files, and swallow a hundred CSV exports into one sheet.
IntermediateCertificate$9.99
Excel VBAExternal Data with SQL (ADO)
Pull exactly the rows you need out of closed workbooks, Access files and SQL Server — without opening a thing.
AdvancedCertificate$9.99
Excel VBAWeb, APIs & JSON
Call a web service from a macro, survive the things that go wrong, and get the answer onto a sheet.
AdvancedCertificate$9.99
Excel VBAClass Modules & Structure
Build your own objects, then use them to turn a thousand-line macro into something you can still read next year.
AdvancedCertificate$9.99
Frequently asked questions
Can I run VBA code in the browser?
No. VBA runs in desktop Excel for Windows and, with some limits, on Mac. The courses explain the code and check your understanding; you run the macros in your own copy of Excel.
Is VBA still worth learning?
Yes, wherever work happens in desktop Excel. A large share of business workbooks rely on it, and it remains the most direct way to automate Excel from the inside.
How much does a course cost?
Each course is a single purchase of $9.99. That covers every lesson and lab, the final exam and the certificate, with no subscription and nothing that renews.
More categories
Ready to learn by doing?
Start with the recommended course and build your first result in the lab today.