Home
AI Vibe Coding for Excel VBA

Sessions 2 days
Duration 15 hrs
Level Beginner
Assessment NA

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.

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.

AI Vibe Coding for Excel VBA

Course Code: C357

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

No funding is available for this course

For WSQ funding, please checkout the details at WSQ - AI Vibe Coding for Excel VBA

Course Fee

$700.00 (GST-exclusive)

$763.00 (GST-inclusive)

Mode of Training

Physical Classroom Training
Synchronised Teaching using ZOOM
Corporate Training at Company Premise

Course Date * Course Date

Course Time * Course Time

9:30am - 5:30pm

No. of Participants

Sponsorship

Self-Sponsored
Employer-Sponsored

Name(s) on Certificate *

Additional Message or Emails for Course Notification

* Required Fields

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

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.

Target Age Group: 18-65 years old

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

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

Ken Hiong is a ACTA certified trainer. Ken has over 20 years of work experience in the healthcare and pharmaceutical industry, having assumed various functional and managerial roles in sales, marketing, business development, finance, business analysis and planning. With an interest and experience in scripting, Ken has worked on projects using HTML, CSS, PHP, MySQL, WordPress, MS Office, VBA, Power BI, etc. Notably, Ken is a proven expert Excel user at work who has made efficient many work processes, improved data analysis and enhanced the quality of business planning and reporting for organizations. Ken graduated with a Pharmacy degree, holds a Master of Business Administration from the National University of Singapore and a Master of Applied Finance from the University of Adelaide. An ardent advocate of lifelong learning, Ken is ACTA trained and seeks to continually upgrade his IT skills through various channels of learning and Microsoft certifications. With MS Office Master qualification, Ken looks forward to assisting individuals and corporations improve their computer skills, productivity and business outcomes.

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.

Liew Sing Loon is a ACTA certified trainer. Liew Sing Loon graduated from the National University of Singapore (NUS) in 1992 with a Second Upper Honors Degree in Electrical Engineering. He started his career as an Electronic Product Design Engineer for four years in a Multinational Company which sell the products worldwide. The job provided him practical knowledge in various aspects of manufacturing operations ranges from Design, Quality, Production and Procurement. He then spent fifteen years in Information Technology Sector as a Key Account Manager in selling IT solutions to Banking, Telecommunications and Government clients. The job provided him the opportunities to propose IT solutions, integrating software, hardware and services, to solve customers’ problems to achieve their strategic business objectives. He joint a German Product Test company to develop its business in providing product Safety, Immunity, Electromagnetic Compatibility (EMC) Certification test. While working in the industry, Liew Sing Loon obtained a Master of Science (MSc) in Technology Management from NUS.
In the last decade, Liew Sing Loon has been Adjunct Lecturer in several Institutes of high learning, transferring his knowledge on Quantitative & Statistical Analysis, Operations, Project & Quality Management to learners ranging from Diploma, full time undergraduates and working adults.Liew Sing Loon has a Certificate of Completion in Education Psychology Course and Teaching & Learning in Higher Education Program conducted by National Institute of Education (NIE).

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.

Review

Customer Reviews (29)

might recommend Review by Course Participant/Trainee

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

. (Posted on 5/3/2021)

will recommend Review by Course Participant/Trainee

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

. (Posted on 9/19/2020)

will recommend Review by Course Participant/Trainee

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

- go through all exercise, can skip the slides.
- give some tips and trick like how to use object orient, customized the ribbon, useful toolbars (Posted on 8/17/2020)

will recommend Review by Course Participant/Trainee

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

It was quite comprehensive, but being nitpicky maybe the slides might've been more suited to newer versions of excel as some functions like modulus had the old symbols listed in the slides. (Posted on 8/17/2020)

might recommend Review by Course Participant/Trainee

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

- there are some error with slides:
1)Workbooks.Open - never specific relative path
2)Last exercise, variable in case is sales
3) Arthimetic operator : % is not in used.
4) Do while loop does not function

2nd, show on how to improve programming productivity, customized ribbons, error handling, object class modules, understand it is a day course, do a bit of touch and go.

3rdly, the entire class just use option explicit, force all variable need to declare data type, just show one counter example.

4th, just save time on the slides do the entire exercises.
the reason I say might recommend is I got some background in word VBA (Posted on 8/17/2020)