Audience and level
Beginners with solid Excel (formulas, ranges) who want their first macros. Intermediate users with recorder clutter to clean up. No CS degree, but willingness to work in the editor.
Duration and format
Typically 1 to 2 days depending on starting point. Day 1: editor, syntax, first procedures. Day 2: loops, files, error handling, exercise on your target flow. Remote or in-house, 4 to 10 participants recommended.
Sample agenda
- Editor, modules, ThisWorkbook, security (.xlsm)
- Understand the recorder, then clean up deliberately
- Variables, If/Select, loops without spaghetti
- Ranges, tables, ListObjects
- On Error, debugging, user messages
- CSV/PDF export as a small tool
Typical issues we address
Common symptoms: macros that only run on the author's machine. Copy-pasted code from the internet nobody fully understands. A recorded script that crashes the moment the sheet changes slightly. We build code a second person can actually follow.
Practical exercises
We sketch a recurring flow from your environment (anonymised), build it step by step in a demo workbook, and discuss maintenance and team handover.
Request VBA training
Describe the recurring flow in a few sentences. I will suggest 1 or 2 suitable days.