Choose “Save as PDF” as the destination to email Spreadsheet Automation with Macros and Scripting to a client.
EasyUphill
CORPORATE DEVELOPMENT
+27 81 041 7673
training@eubiz.co.za
68 Sunstone Street, Germiston, 1401
eubiz.co.za
training@eubiz.co.za
68 Sunstone Street, Germiston, 1401
eubiz.co.za
IT & Digital Skills
Spreadsheet Automation with Macros and Scripting
Duration
3 Days
Delivery
In-house, public or online
From
R13,000 per delegate
Certificate
On completion
Course overview
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.
What you will be able to do
- 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
Course outline
01
Choosing what is worth automating
02
Recording actions and understanding the generated code
03
Variables, loops and conditions in practice
04
Structuring procedures with sensible naming
05
Error handling and unexpected data
06
Simple interfaces, buttons and prompts for other users
07
Documentation, handover and maintainability
Upcoming public sessions
| Dates | Venue | Duration | Fee per delegate |
|---|---|---|---|
| 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 exclude VAT. This course can also be delivered in-house at your premises on dates that suit your team, or live online.
To book or ask for an in-house quote
Reply to the email this brochure came with, call +27 81 041 7673, or visit eubiz.co.za and open this course.
EasyUphill Training & ConsultingTailored training that moves teams forward.
+27 81 041 7673 · training@eubiz.co.za
68 Sunstone Street, Germiston, 1401 · eubiz.co.za
68 Sunstone Street, Germiston, 1401 · eubiz.co.za