Home
WSQ - AI Vibe Coding for Excel VBA

Sessions 2 days
Duration 16 hrs
Level Beginner
Assessment 2 hrs

Venue

12 Woodlands Square #07-85/86/87 Woods Square Tower 1, Singapore 737715. 5 mins walk from Woodlands (NS9) MRT station.

The venue is disabled-friendly.

TSC Title: Software Design
TSC Code: ICT-DES-3005-1.1

Funding for this course is valid from 27 Sep 2021 to 26 Sep 2027. Register and complete the course within this period to qualify for funding support.

By the end of the course, learners will be able to

LO1: Design simple Excel interface using VBA and Macro
LO2: Perform VBA programming methods and tools
LO3: Create user defined functions to meet design objectives
LO4: Manage Excel objects functionality and interoperability
LO5: Produce user defined forms and documentation

Download Course Brochure

Certificate of Achievement from Tertiary Infotech Academy Pte Ltd - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Achievement from Tertiary Infotech Academy Pte Ltd.
OpenCerts from SkillsFuture Singapore - After passing the assessment(s) and achieving at least 75% attendance, participants will receive a OpenCert (aka Statement of Achievement) from SkillsFuture Singapore, certifying that they have achieved the Competency Standard(s) in the above Skills Framework.

WSQ - AI Vibe Coding for Excel VBA

Course Code: TGS-2021008700

WSQ
SFC
PSEA
SFEC
Absentee Payroll
MCES

93 Review(s) | Add Your Review

This course equips participants with practical skills to use AI vibe coding to create and improve Excel VBA automation solutions. Learners will use natural-language instructions and AI coding assistants to generate, explain, test, debug, and refine VBA code, enabling them to automate spreadsheet tasks without writing every line of code manually.

Participants will learn essential Excel VBA concepts, including the Visual Basic Editor, macros, variables, data types, procedures, functions, conditional statements, loops, and event-driven programming. They will apply these concepts to automate repetitive activities such as data entry, formatting, calculations, report generation, workbook management, and data validation.

The course also covers developing custom functions, creating interactive forms and controls, processing large datasets, handling errors, and integrating multiple worksheets and workbooks. Learners will use AI-assisted workflows to convert business requirements into working VBA solutions, troubleshoot code, and improve the reliability and maintainability of spreadsheet applications.

Through hands-on business projects, participants will build end-to-end Excel automation workflows that reduce manual effort, minimise errors, and improve operational efficiency. Emphasis is placed on reviewing AI-generated code, protecting sensitive data, documenting solutions, and applying safe macro practices.

By the end of the course, learners will be able to use AI vibe coding to design, develop, test, and maintain Excel VBA applications for finance, administration, operations, reporting, and other data-intensive business functions.

Full Fee $750.00 Before GST

GST $67.50 9% of fee

Baseline Nett $442.50 SG/PR age 21+ · 50% funded

MCES / SME Nett $292.50 SG age 40+ · 70% funded

SkillsFuture Enterprise Credit (SFEC)

Eligible companies can use their $10,000 SFEC to cover up to 90% of out-of-pocket course fees for classes ending on or before 30 Nov 2026. A redesigned SFEC starts on 1 Dec 2026.

View on SkillsFuture for Business

SkillsFuture Credit (SFC)

Eligible Singapore Citizens can use their SFC to offset course fee payable after funding but the $4,000 Additional SFC (Mid-Career Support) cannot be used.

Direct Application on SkillsFuture Portal

PSEA

Eligible Singapore Citizens can use their PSEA funds to offset course fee payable after funding.

Check PSEA Eligibility

Scroll down to “Keyword Tags” to verify for PSEA eligibility.
If there is “PSEA” under keyword tags, the course is eligible for PSEA.

Once you are eligible for PSEA, please download and fill up the PSEA Withdrawal Form, then submit the completed form to us:

PSEA Withdrawal Form Submit PSEA Form

Please bring your own laptop for hands-on training. If you don't have laptop, we can provide spare laptop for training use.

We provide free consultation related to the subject matter after the course.
Please email your queries to enquiry@tertiaryinfotech.com and we will forward your queries to the subject matter experts.

You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commences.
We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% for any paid amount.
Note the venue of the training is subject to changes due to availability of the classroom.

Course Details

Topic 1: AI Vibe Coding for Excel VBA, Macros and Interface Design

Topic 2: VBA Programming Logic, Variables, Decisions and Loops

Topic 3: Creating Custom Functions and Automated Procedures

Topic 4: Managing Excel Objects, Testing and Debugging VBA Code

Topic 5: Developing User-Defined Forms, Events and Documentation

Written Exam
Practical Exam

Course Info

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 will need the following for this course:

Microsoft Excel (desktop app, Microsoft 365)
A free account on a generative AI assistant of your choice, e.g. ChatGPT, Google Gemini or Microsoft Copilot (the free tier is sufficient)

Hardware: Windows PC or Mac laptop

Funding Eligibility Criteria

Self-sponsored learners (individuals)

Singapore Citizens and Singapore Permanent Residents aged 21 and above.
Up to 50% course fee funding. Singapore Citizens aged 40 and above receive up to 70% under the Mid-career Enhanced Subsidy (MCES).
Singapore Citizens aged 25 and above can pay the remaining fee with SkillsFuture Credit.

Company-sponsored learners

Singapore Citizens and Singapore Permanent Residents who are direct employees of the sponsoring company.
Up to 50% course fee funding, or up to 70% for employees of SMEs (Enhanced Training Support for SMEs) and for Singapore Citizens aged 40 and above. An SME has no more than 200 employees or an annual turnover of no more than $100 million.
Employers can also claim Absentee Payroll funding for employees who attend during working hours.
Eligible companies can offset their out-of-pocket fees with SkillsFuture Enterprise Credit (SFEC).

Conditions for all funded learners

Attendance is taken digitally with Singpass for every session, including the assessment.
You must complete the course and pass all assessments (assessed as Competent).
If these conditions are not met, the funding is clawed back and the learner or employer pays the full course fee.
9% GST is charged on the full course fee before funding.
Promo and discount codes cannot be used on funded courses.
Any balance after funding can be paid in cash, with SkillsFuture Credit, with PSEA (Singapore Citizens with a PSEA).

How to Apply SkillsFuture Credit Claim for Individuals

Singapore Citizens aged 25 and above can use their SkillsFuture Credit (base tier) to pay the course fee after funding. The $4,000 mid-career top-up cannot be used for this course.

Register for this course as self-sponsored and tell us you will use SkillsFuture Credit. Do not pay the amount you plan to claim.
We email you an invoice showing the course fee after funding.
From 60 days before the course starts, and no later than the course start date, log in to MySkillsFuture with Singpass and click Claim credits.
Click Submit a Claim and search for this course by its course code, TGS-2021008700.
Select your class start date, enter the course fee payable after funding and the amount of credit to claim, then upload the invoice (PDF, JPG or PNG, under 4MB).
Review, accept the terms and click Agree and Submit. The credit is paid directly to us; processing can take up to 14 working days.

Changing or withdrawing: cancel the claim on MySkillsFuture at least one day before the course starts. If your class date changes, cancel the claim and submit a new one with the new date.

How to Apply SkillsFuture Enterprise Credit (SFEC)

SFEC helps companies pay for employee training. The current SFEC ends on 30 November 2026, and a redesigned SFEC starts on 1 December 2026.

Current SFEC: classes ending on or before 30 November 2026

Eligible companies received a one-off $10,000 credit, notified by letter to their Corppass administrator. Eligibility generally required at least 3 Singapore Citizen or PR employees and Skills Development Levy contributions.
SFEC covers up to 90% of the company's out-of-pocket course fee after other subsidies.

Check your company's SFEC eligibility and balance on EnterpriseSG.
Register your Singapore Citizen or PR employee for a class that ends by 30 November 2026, as company-sponsored, and pay the course fee after funding.
Your employee attends and completes the course. We submit the attendance and assessment results to SWDA.
No separate claim is needed. SFEC is calculated automatically once the course fee grant is approved and is paid quarterly to your company's IRAS GIRO or PayNow Corporate account.

Any unused balance of the current SFEC expires on 30 November 2026.

Redesigned SFEC from 1 December 2026

Companies with at least 3 resident employees receive a fresh $10,000 in an online SFEC wallet that offsets out-of-pocket fees upfront at enrolment, instead of reimbursing them afterwards. SWDA has not yet published the support rates and claim steps; see OurWorkforce or our SFEC guide.

How to Apply PSEA

Singapore Citizens with a Post-Secondary Education Account (PSEA), which stays open until around the year you turn 31, can use it to pay the course fee after funding for PSEA-approved courses. You can also use a sibling's PSEA after your own has been used up.

Check that this course shows the PSEA tag on its MySkillsFuture page.
Check your PSEA balance on MOE's Student Finance System with Singpass.
Download and complete the PSEA withdrawal form, then submit it to us.
We submit the withdrawal request to MOE. You (and your sibling, if you are using their account) authorise it in the Student Finance System. Nothing is withdrawn without this authorisation.
MOE pays us directly. If you have already paid, we refund the amount covered by PSEA.

More details: MOE PSEA overview.

Appeal Process

If you disagree with an assessment decision, you have the right to appeal.

When the assessor gives you feedback, say whether you agree with the outcome. If you agree, you and the assessor sign the Assessment Summary Record; if you disagree, do not sign it.
Discuss the decision with the assessor or the assessment manager first.
If you are still not satisfied, tell the assessor you intend to appeal. The assessor records this in the feedback section of the Assessment Summary Record and informs the assessment manager.
Lodge your appeal within 7 days, giving your reasons, using the Candidate Appeal Form. The assessor can help you write and lodge it.
An Assessment Appeal Panel reviews the information from you and the assessor and makes a decision. A record of the appeal and its outcome is kept.
You will be told the outcome within 2 weeks of lodging the appeal. The panel's decision is final.

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 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.

Terence Ee is an experienced IT leader and consultant with more than 25 years of expertise in technology management, information systems, and digital transformation. He has served as Chief Information Officer at the Supreme Court of Singapore and Vice President of Information Systems at Senoko Energy, where he led major IT modernization projects. Since 2017, he has worked as an independent consultant and ACLP-certified trainer, specializing in guiding SMEs and enterprises in adopting future-ready digital platforms. As a WSQ-accredited trainer, Terence delivers programs in digital collaboration, IT governance, and productivity tools. His facilitation emphasizes case studies, simulations, and hands-on practice, enabling learners to apply modern IT systems such as Microsoft 365 and Google Workspace to improve collaboration and business efficiency. With his leadership background and deep IT expertise, Terence prepares learners to thrive in digitally transforming environments.

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.

Dwight Nuwan Fonseka is Head of Data Science at Plano Pte. Ltd. and an ACLP-certified trainer with deep expertise in data analytics, machine learning, and AI applications. He has extensive hands-on experience developing predictive models, RShiny dashboards, and deep learning solutions using R, Python, TensorFlow, and Keras. With a strong professional background in healthcare, finance, and customer analytics, Dwight brings an applied perspective to teaching AI, focusing on both the opportunities and risks of emerging technologies.

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 “AI Vibe Coding for Excel VBA,” Dr. Ang provides participants with a comprehensive understanding of AI vibe coding, 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.