WSQ Data Automation using Excel VBA Programming Course
Professional WSQ Data Automation using Excel VBA Programming Course for Career Growth
Eligible companies can enjoy enhanced funding support when sponsoring staff for training:
* Claim up to $4.50/hour per participant under Absentee Payroll
* Receive up to 90% funding of the payable course fees through SFEC
This is on top of the existing WSQ course fee subsidies, helping companies significantly reduce their overall training costs.
Schedule
- Days: 3 Days
- Duration: 24 Hours
- Timings: 9:00 AM - 6:00 PM
- 10 Anson Road, 26-08A International Plaza, Singapore 079903
Why Choose Us
- Expert Local Trainers
- Hands-on Training by experts
- Certificate of Achievement
SSG Course Details
- TGS-2023041097
- Mode of Training - Physical, in-class training
- Course Subsidy Validity - From 28 Dec 2023 to 27 Dec 2027
Training fee:
Funding: (GST included)
*The funding amount mentioned is indicative and will be
confirmed upon registration.
| Self-sponsor/ Non-SME Company Sponsor | SME Company Sponsor | |||
|---|---|---|---|---|
| Full Course Fee (no funding) |
Age 21-39 S/PRs (SkillsFuture Funding Baseline) |
Age 40 above (SkillsFuture Mid-career Enhanced Subsidy) |
SME Company Sponsor (SkillsFuture Enhanced Training support for SMEs) |
|
| Full Course Fee (bef funding) | $795.00 | $795.00 | $795.00 | $795.00 |
| SkillsFuture Funding (WSQ) | - $0.00 | - $397.50 | - $556.50 | - $556.50 |
| GST (On Full Fee) | + $71.55 | + $71.55 | + $71.55 | + $71.55 |
|
Total Payable (After Funding and GST Included) |
$866.55 | $469.05 | $310.05 | $310.05 |
Payable amount after WSQ funding is eligible for further support from SFEC, SkillsFuture, PSEA & UTAP where applicable.
Kindly note that you are required to achieve a minimum of 75% attendance and be certified competent in all the assessment components. Should you fail to meet the attendance/assessment requirements and/or terms and conditions of SSG’s funding, you will not be eligible for the course fee funding and will have to bear the full course fees.
Discount Policy:
- 4 pax from a same group: 5% discount for each person
- 5 pax from a same group: 10% discount for each person
Grants Available
WSQ
Singapore Workforce Skills Qualifications
Baseline funding deduction upto 70% for Singaporeans/ PRs. Further SFEC, Absentee Payroll and WSS applicable.
SkillsFuture
Eligible
Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees
PSEA
Post-Secondary Education Account are available for Singaporean Citizens to cover the approved fees and charges related to WSQ programs.
SFEC
Eligible companies can offset up to 90% of the payable amount via SFEC
Absentee Payroll
Eligible companies can reimburse $4.50 per hour/pax joining our courses from Absentee Payroll
Who Should Attend
Student
Bookkeeper
Finance Professionals
Entrepreneur
Analyst
Course Completion Requirements
Minimum 75% attendance & Passing the assessment by the end of the course is required in order to complete the course and receive the course completion certificate as well as course fee subsidy funding
Above 16 years old
High School Level English
Basic internet & computer operation skills
WSQ Data Automation Using Excel VBA Programming in Singapore
- Professionals involved in data analysis, modelling, and reporting within organisations
- Data analysts who want to automate data manipulation and reporting tasks in Excel
- Finance professionals working on financial modelling, forecasting, and analysis
- Accountants handling financial reporting and data analysis using Excel
- Administrative staff managing data, records, and reports efficiently
- Project managers using Excel for planning, tracking, and reporting
WSQ Data Automation using Excel VBA Programming Course Outline
Lesson 1. Visual Basic for Applications (VBA) for Office (1.5 Hrs)
- Recognizing the need and uses for VBA applications (K2)
- Get started with Visual Basic for Applications (K2)
- Displaying the Developer tab in the Ribbon (A1)
- Understanding the development environment (A1)
- Understanding macro security (A1)
Lesson 5. Working with Forms and Controls (3 Hrs)
- Understanding UserForms (K7)
- Using the Toolbox (K7)
- Working with UserForm Properties, Events, and Methods (K7)
- Understanding Controls (K7)
- Setting Control Properties in the Properties Window (K7)
- Working with the Controls (A9)
- Label Control
- Text Box Control
- Command Button Control
- Combo Box Control
- Frame Control
- Option Button Controls
- Control Appearance
- Setting the Tab Order
- 6.7 Populating a Control (A9)
- Adding Code to Controls
- Launching a Form in Code
Lesson 2. Working with Procedures and Functions (2 Hrs)
- Understanding Modules (K4)
- Understanding Procedures (K4)
- Sub Procedure (K4)
- Creating a Function Procedure (A2)
- Naming Procedures (A2)
- Working with the Code Editor (A2)
Lesson 3. Understanding objects, methods, properties, and events (3 Hrs)
- Understanding and Navigating Excel Object Hierarchy (K1)
- Understanding Collections (K1)
- Using the Object Browser (K1)
- Working with Properties (K1)
- Using the “WITH” Statement (A3)
- Working with VBA Methods (A3)
- Creating an Event Procedure (A3)
Lesson 4. Controlling Program Execution (4 Hrs)
- Understanding Control-of-Flow Structures (K5)
- Working with Boolean Expressions (K5)
- Using the If…End If Decision Structures (A4)
- Using the Select Case…End Select Structure (A4)
- Using the Do…Loop Structure (A4)
- Using the For…To…Next Structure (A4)
- Using the For Each…Next Structure and guidelines for control-of-flow (A4)
Lesson 6. Gathering User input (2 Hrs)
- Gathering user input Using dialog boxes (A8)
Lesson 7. Debugging Code (1.5 Hrs)
- Understanding Errors (A7)
- Using Debugging Tools (A7)
- Setting Breakpoints (A7)
- Stepping through Code (A7)
- Using Break Mode during Run mode (A7)
- Determining the Value of Expressions (A7)
Lesson 8. Handling Errors (1.5 Hrs)
- Understanding Error Handling (K3)
- Understanding VBA's Error Trapping Options (K3)
- Trapping Errors with the On Error Statement (K3)
- Writing an Error-Handling Routine (A6)
FAQ for WSQ Data Automation using Excel VBA Programming Course
What is the WSQ Data Automation Using Excel VBA Programming course?
The course teaches you how to automate data processing tasks in Excel using VBA (Visual Basic for Applications), improving efficiency and accuracy in your work.
What if I fail/did not complete the assessment?
You will be considered non-competent and no Statement of Attainment (SOA) will be awarded.
You are required to pay the complete course fee, which includes the SSG’s funding requirement.
How long is the course, and what is the format?
No prior programming experience is required. Basic knowledge of Excel functions and formulas is required, but the course is designed for advanced Excel users.
What will I learn in this course?
You will learn to create macros, automate tasks, write VBA code for data processing, use Excel’s VBA editor, and apply data automation to real-world scenarios.
Do I need any prior experience in accounting to take this course?
The course is conducted over 3 days and combines theoretical lessons with practical hands-on exercises to ensure skill mastery.
Will I receive a certification after completing the course?
Yes, upon successfully completing the course and assessments, you will receive a WSQ certification in Data Automation using Excel VBA Programming.
Can this course help me in my current job?
Who is this course suitable for?
ADDITIONAL SUPPORT
For Company
* Eligible companies can reimburse up to 90% of the payable amount via SFEC
For Self-sponsor
* Singaporean can offset the payable amount via SkillsFuture Credit (Except Mid Career Credit) and/or PSEA
* NTUC Union members can reimburse of up to 50% of the unfunded fee under UTAP Enjoy up to $250 UTAP support. More info: UTAP
Note: minimum 75% attendance & passing all the assessment are required for WSQ subsidy deduction.
Start Your WSQ Data Automation using
Excel VBA Programming Course
© 2026 All Rights Reserved.
