You have no items in your shopping cart.
Course Details
Topic 1: Get Started on VBA
- What is VBA
- Access VBA from Excel
- Write Your First VBA Code
- VBA Macro
Topic 2: VBA Programming
- Variables and Constants
- Data Types and Array
- Operators
- Decision
- Loops
Topic 3: Function and Sub Procedure
- Function
- Sub Procedure
Topic 4: Managing Excel Objects
- Excel Objects
- Testing and Debugging
Topic 5: Create User Defined Forms
- • User forms
- • Events and Event Procedure
Final Assessment
- Written Assessment - Short Answer Questions (WA-SAQ)
- Practical Performance (PP)
Course Info
Promotion Code
Promo or discount cannot be applied to WSQ courses
Minimum Entry Requirement
Knowledge and Skills
- Able to operate using computer functions
- Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)
Attitude
- Positive Learning Attitude
- Enthusiastic Learner
Experience
- Minimum of 1 year of working experience.
Minimum Software/Hardware Requirement
Software:
You can download and install the following software:
Hardware: Windows and Mac Laptops
About Progressive Wage Model (PWM)
The Progressive Wage Model (PWM) helps to increase wages of workers through upgrading skills and improving productivity.
Employers must ensure that their Singapore citizen and PR workers meet the PWM training requirements of attaining at least 1 Workforce Skills Qualification (WSQ) Statement of Attainment, out of the list of approved WSQ training modules.
For more information on PWM, please visit MOM site.
Funding Eligility Criteria
| Individual Sponsored Trainee | Employer Sponsored Trainee |
|
|
|
SkillsFuture Credit:
PSEA:
|
Absentee Payroll (AP) Funding:
SFEC:
|
Steps to Apply Skills Future Claim
- The staff will send you an invoice with the fee breakdown.
- Login to the MySkillsFuture portal, select the course you’re enrolling on and enter the course date and schedule.
- Enter the course fee payable by you (including GST) and enter the amount of credit to claim.
- Upload your invoice and click ‘Submit’
SkillsFuture Level-Up Program
The SkillsFuture Level-Up Programme provides greater structural support for mid-career Singaporeans aged 40 years and above to pursue a substantive skills reboot and stay relevant in a changing economy. For more information, visit SkillsFuture Level-Up Programme
Get Additional Course Fee Support Up to $500 under UTAP
The Union Training Assistance Programme (UTAP) is a training benefit provided to NTUC Union Members with an objective of encouraging them to upgrade with skills training. It is provided to minimize the training cost. If you are a NTUC Union Member then you can get 50% funding (capped at $500 per year) under Union Training Assistance Programme (UTAP).
For more information visit NTUC U Portal – Union Training Assistance Program (UTAP)
Steps to Apply UTAP
- Log in to your U Portal account to submit your UTAP application upon completion of the course.
Note
- SSG subsidy is available for Singapore Citizens, Permanent Residents, and Corporates.
- All Singaporeans aged 25 and above can use their SkillsFuture Credit to pay. For more details, visit www.skillsfuture.gov.sg/credit
- An unfunded course fee can be claimed via SkillsFuture Credit or paid in cash.
- UTAP funding for NTUC Union Members is capped at $250 for 39 years and below and at $500 for 40 years and above.
- UTAP support amount will be paid to training provider first and claimed after end of class by learner.
Appeal Process
- The candidate has the right to disagree with the assessment decision made by the assessor.
- When giving feedback to the candidate, the assessor must check with the candidate if he agrees with the assessment outcome.
- If the candidate agrees with the assessment outcome, the assessor & the candidate must sign the Assessment Summary Record.
- If the candidate disagrees with the assessment outcome, he/she should not sign in the Assessment Summary Record.
- If the candidate intends to appeal the decision, he/she should first discuss the matter with the assessor/assessment manager.
- If the candidate is still not satisfied with the decision, the candidate must notify the assessor of the decision to appeal. The assessor will reflect the candidate’s intention in the Feedback Section of the Assessment Summary Record.
- The assessor will notify the assessor manager about the candidate’s intention to lodge an appeal.
- The candidate must lodge the appeal within 7 days, giving reasons for appeal
- The assessor can help the candidate with writing and lodging the appeal.
- he assessment manager will collect information from the candidate & assessor and give a final decision.
- A record of the appeal and any subsequent actions and findings will be made.
- An Assessment Appeal Panel will be formed to review and give a decision.
- The outcome of the appeal will be made known to the candidate within 2 weeks from the date the appeal was lodged.
- The decision of the Assessment Appeal Panel is final and no further appeal will be entertained.
- Please click the link below to fill up the Candidates Appeal Form.
Job Roles
- Data Analyst
- Business Analyst
- Financial Analyst
- Operations Manager
- Marketing Analyst
- HR Metrics Specialist
- Sales Operations Specialist
- Report Developer
- Project Manager
- Management Accountant
- Product Manager
- Supply Chain Analyst
- Performance Metrics Specialist
- Market Researcher
- Business Intelligence Coordinator
Trainers
Jim Gan Chiu Liang: Jim Gan Chiu Liang is an experienced software developer and data automation specialist with over 15 years of experience in designing and implementing Microsoft Excel VBA solutions for business process optimization. His expertise lies in developing automated workflows, interactive dashboards, and complex financial models that reduce manual workload and improve data accuracy. Jim has worked with organizations across finance, logistics, and education sectors, helping them leverage Excel’s advanced programming capabilities to drive efficiency and decision-making.
In “Software Automation with Excel VBA Programming,” Jim focuses on teaching participants how to use VBA to automate repetitive tasks, manage large datasets, and build dynamic business applications. His sessions emphasize practical project development—ranging from macro creation to custom form design—enabling learners to translate business logic into efficient, maintainable code. By combining hands-on exercises with real-world case studies, he empowers professionals to build powerful, automated Excel solutions.
Terence Ee: Terence Ee is a data analytics and business automation consultant with over two decades of experience in digital transformation and corporate training. Specializing in Excel VBA, Power Query, and process improvement, he has led multiple automation projects that streamlined operations for multinational companies and SMEs. His strong background in statistics and data modeling allows him to bridge analytical problem-solving with technical implementation effectively.
In “Software Automation with Excel VBA Programming,” Terence helps participants master the practical application of VBA in automating reporting systems and analytical workflows. His sessions cover advanced Excel concepts, including error handling, loops, and user-defined functions, focusing on how automation enhances productivity and accuracy. With his pragmatic and interactive teaching style, he ensures learners gain confidence in developing tailored VBA solutions for their workplace needs.
Liew Sing Loon (Sen Ru): Liew Sing Loon (Sen Ru) is an IT systems specialist and data analytics educator with extensive experience in software automation and database integration. With a strong background in programming and information management, he has trained professionals in applying Excel VBA and SQL to solve complex business challenges. His expertise in workflow design and automation enables organizations to modernize their reporting systems and streamline data processing.
In “Software Automation with Excel VBA Programming,” Sing Loon focuses on building a strong foundation in coding logic and automation best practices. His sessions emphasize modular programming, user interface design, and efficient data handling in Excel environments. Through structured exercises and case-based learning, he equips learners with the skills to build, test, and deploy automated tools that improve business efficiency and data accuracy.
Dwight Nuwan Fonseka: Dwight Nuwan Fonseka is a data engineer and analytics professional with extensive experience in workflow automation, business intelligence, and software development. Over his career, he has delivered automation and data management solutions using Excel VBA, Python, and SQL across sectors such as finance, logistics, and education. Known for his ability to simplify complex technical topics, Dwight has trained professionals in building scalable data systems and automated reporting frameworks.
In “Software Automation with Excel VBA Programming,” Dwight guides participants through the full process of designing, developing, and deploying VBA-driven automation systems. His sessions focus on creating dynamic data models, automating repetitive processes, and integrating VBA with other business tools. Through his methodical and example-driven approach, he ensures learners gain practical skills to enhance efficiency and reduce errors in data-driven tasks.
Dr. Alfred Ang: Dr. Alfred Ang is a distinguished technologist and educator with more than 20 years of experience in software engineering, automation, and AI-driven data analytics. As CTO and Chief Instructional Designer at Tertiary Infotech, he has developed over 500 accredited programs in areas such as business intelligence, cloud computing, and robotic process automation. His deep expertise in Excel VBA, database systems, and application development allows him to teach automation from both a strategic and technical perspective.
In “Software Automation with Excel VBA Programming,” Dr. Ang provides participants with a comprehensive understanding of VBA programming principles and automation design. His sessions cover macro development, object-oriented coding, and system optimization techniques that enable professionals to build intelligent Excel-based applications. With his blend of academic rigor and real-world experience, he empowers learners to transform manual business processes into streamlined, automated solutions.
Customer Reviews (89)
- will recommend Review by Course Participant/Trainee
-
. (Posted on 8/22/2022)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Trainer is patient, detailed and provided sufficient examples for case studies. Review by Course Participant/Trainee
-
Trainer is patient, detailed and provided sufficient examples for case studies. (Posted on 7/25/2022)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - might recommend Review by Course Participant/Trainee
-
. (Posted on 3/14/2022)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Will Sign up for next Course Review by Course Participant/Trainee
-
Will Sign up for next Course, DashBoard and other Courses under Mr Jim Gan (Posted on 3/13/2022)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Mr Gan is a very good instructor Review by Course Participant/Trainee
-
Mr Gan is a very good instructor who make sure we learn our work well and his notes is very impressive. (Posted on 3/13/2022)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
Cater more time for some parts (Posted on 2/25/2022)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommmend Review by Course Participant/Trainee
-
Create a project for students to work on an actual complete project (Posted on 11/23/2021)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
. (Posted on 11/22/2021)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
. (Posted on 11/19/2021)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment
Write Your Own Review
You May Be Interested In These Courses
WSQ - Statistical Data Analysis with Excel for Beginners
$350.00 (GST-exclusive)
$381.50
(GST-inclusive)
WSQ - Data Analytics and Visualization with Power BI
$800.00 (GST-exclusive)
$872.00
(GST-inclusive)
