Intermediate track

Intermediate lessons

Handle data with arrays and dictionaries, add error handling, and build reusable tools.

1. 1

   VBA Arrays for Bulk Data

   Read ranges into arrays, process in memory, and write results back in one shot.

2. 2

   Dictionary for Lookups and Deduplication

   Replace nested loops with O(1) key lookups using Scripting.Dictionary.

3. 3

   Functions vs Subs

   Return values from Functions and keep side effects in Subs.

4. 4

   Error Handling That Survives Production

   Use On Error GoTo, clean up objects, and leave workbooks in a safe state.

5. 5

   Find, Copy, and Filter Data

   Automate the copy-paste-filter routines that eat hours every close.

6. 6

   String Functions for Messy Data

   Trim, split, and normalize text fields before validation or export.

7. 7

   Introduction to UserForms

   Build a small form for parameters instead of hard-coding values in macros.

Back to all tracks