Spreadsheet Automation with Macros and Scripting
Repetitive spreadsheet work consumes hours that automation can return, provided the automation is written to be maintained. This course covers recording, writing and structuring automation that survives its author.
Course outline
What this programme covers, module by module.
- 01Choosing what is worth automating
- 02Recording actions and understanding the generated code
- 03Variables, loops and conditions in practice
- 04Structuring procedures with sensible naming
- 05Error handling and unexpected data
- 06Simple interfaces, buttons and prompts for other users
- 07Documentation, handover and maintainability
What you will gain
- Identify spreadsheet work worth automating
- Record and then improve generated code
- Write procedures with sensible structure and naming
- Handle errors and unexpected data safely
- Build simple interfaces for other users
- Document and hand over automation
Who should attend
- Finance and operational analysts
- Administrative staff with repetitive tasks
- Reporting and data staff
- Anyone maintaining complex workbooks
Upcoming sessions
| Date | City | Duration | Fees | Book |
|---|---|---|---|---|
| 27 to 29 Oct 2026 | London | 3 Days | US$1,500 | |
| 16 to 18 Nov 2026 | Dubai | 3 Days | US$1,500 | |
| 30 Nov to 2 Dec 2026 | Pretoria | 3 Days | R13,000 | |
| 11 to 13 Jan 2027 | Durban | 3 Days | R13,000 | |
| 15 to 17 Feb 2027 | Cape Town | 3 Days | R13,000 | |
| 19 to 21 Apr 2027 | Johannesburg | 3 Days | R13,000 | |
| 21 to 23 Jun 2027 | London | 3 Days | US$1,500 |
Fees are per delegate and exclude VAT. Public intakes are confirmed once minimum numbers are met. We also deliver this course on your own schedule, in-house or live online.
Enquire about this course
Register your team or ask for a tailored in-house quote. We reply within one working day.
WhatsApp usCourse brochure (PDF)- Fees from
- R13,000 per delegate
- Duration
- 3 Days
- Field
- IT & Digital Skills
- Formats
- In-house, public, online
More in IT & Digital Skills
Cybersecurity Fundamentals for Professionals
Every organisation now depends on systems and data that attackers actively seek to exploit. This course builds a practical understanding of cyber threats and the defences that reduce them. Participants study common attacks, security controls, and the response to incidents.
Spreadsheet to Database Migration for Teams
Teams outgrow a shared spreadsheet long before they admit it, usually at the point where two people are editing different copies. This course covers moving that work into something that holds.
Cloud Computing Foundations
Cloud services have changed how organisations build, run, and pay for technology. This course explains the concepts, models, and benefits of cloud computing in plain terms. Participants examine service models, deployment options, and the basics of cost and security.