Excel VBA, start to finish

🧱

VBA Basics

Open the editor, write your first working macro, and understand every line of it.

8 lessons · 50 min · Beginner

Start

🔲

Ranges & Cells

Point your code at exactly the right cells and read or write them without ever clicking.

8 lessons · 52 min · Beginner

Start

🔁

Logic & Loops

Make your macros decide for themselves and repeat work across thousands of rows.

8 lessons · 51 min · Beginner

Start

⏺

Macro Recorder & Cleanup

Record what Excel does, read the code it produces, and rewrite it into something fast and reliable.

8 lessons · 52 min · Beginner

Start

📑

Worksheets & Workbooks

Point your code at the right sheet and the right file, every single time.

7 lessons · 53 min · Intermediate

Start

🐞

Errors & Debugging

Find out what your macro is really doing, and fail gracefully when something goes wrong.

8 lessons · 60 min · Intermediate

Start

🪟

UserForms

Build proper data-entry windows so people stop typing straight into your spreadsheet.

7 lessons · 53 min · Intermediate

Start

⚙️

Automation & Reports

Let Excel react on its own, gather data from a folder, and send the finished report out the door.

8 lessons · 62 min · Intermediate

Start

⚡

Arrays & Performance

Pull a whole range into memory, do the work there, and write it back in a single line — hundreds of times faster.

7 lessons · 49 min · Advanced

Start

🗂

Collections & Dictionary

Group, count and de-duplicate thousands of rows in one pass using keys instead of nested loops.

7 lessons · 49 min · Advanced

Start

✂️

Text & Strings

Cut, search, split, join and reshape messy text until it looks like clean data.

7 lessons · 47 min · Intermediate

Start

📅

Dates & Times

Build, compare, shift and format dates reliably — including the text ones that arrived from somebody else's system.

7 lessons · 48 min · Intermediate

Start

🧮

Custom Functions (UDF)

Write your own worksheet functions in VBA and use them in cells just like SUM or VLOOKUP.

8 lessons · 60 min · Intermediate

Start

📊

PivotTables with VBA

Build, fill, filter and refresh PivotTables entirely in code, so a monthly report becomes one click.

7 lessons · 53 min · Advanced

Start

📈

Charts with VBA

Create, format and export Excel charts from code so every report looks identical every month.

7 lessons · 52 min · Intermediate

Start

🧾

Excel Tables (ListObjects)

Stop guessing where your data ends — drive real Excel Tables from VBA and let them resize themselves.

7 lessons · 54 min · Intermediate

Start

📁

Files, Folders & CSV

Let your macros walk through folders, read and write text files, and swallow a hundred CSV exports into one sheet.

8 lessons · 59 min · Intermediate

Start

🗄

External Data with SQL (ADO)

Pull exactly the rows you need out of closed workbooks, Access files and SQL Server — without opening a thing.

8 lessons · 59 min · Advanced

Start

🌐

Web, APIs & JSON

Call a web service from a macro, survive the things that go wrong, and get the answer onto a sheet.

8 lessons · 60 min · Advanced

Start

🏛

Class Modules & Structure

Build your own objects, then use them to turn a thousand-line macro into something you can still read next year.

8 lessons · 60 min · Advanced

Start