Automation using Visual Basic for Applications

Course Reference Number:

Course Content:
MS Excel is a ubiquitous application which is indispensable in many companies. Users can harness the full potential of MS Excel by automating repetitive and manual tasks using Excel VBA. Through automation, users can also improve their productivity and reduce human errors in data processing. In this course, the learners will learn how to automate complex tasks and get more meaningful insights from data in Excel using Visual Basic for Applications (VBA) code.

Course Objectives:
This course aims to enhance the productivity of users using MS Excel by reducing the time spent on repetitive and manual data processing tasks and minimising human errors through spreadsheet automation using MS Excel VBA. Participants will learn how to write Excel VBA codes from scratch and this serves to build a basic understanding to develop simple software automation using Excel VBA programming.
Learners are required have basic MS Excel knowledge and to bring their own laptop computers (Windows only with Microsoft Excel 2016 or above installed)

Upcoming class:
7 – 8 Mar 2024
(9am – 6pm)

Trade Association Hub (Jurong Town Hall)

Nett Fees Payable (inclusive of 9% GST): 

• SME-sponsored: $187.20
(SC/PR of all ages)
• Non-SME sponsored/ Self-sponsored: $283.20
(SC below 40 years old; PR of all ages)
• Non-SME sponsored/ Self-sponsored: $187.20
(SC 40 years old and above)
U.P. $532.20

Funding & Claims
To be eligible for funding, company-sponsored staff attending courses must be employed by company, and company also contributes CPF to staff.
– Foreigners may attend short courses but are not entitled to course fee subsidy and absentee payroll funding.
– SkillsFuture Enterprise Credit(SFEC) supportable (
– SkillsFuture Credit eligible
– Absentee payroll claimable ($4.50 per hour).
– Supported under NTUC’s UTAP
– PSEA (Post-Secondary Education Account) -approved
Self-sponsored individuals must be at least 21 years old