• Home
  • AI Vibe Coding for Excel VBA

Visual Basic Application (VBA) for Excel Training in Singapore

Course Information

  • 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

Certification

  • Certificate of Completion from Tertiary Courses - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from Tertiary Courses.

AI Vibe Coding for Excel VBA

Course Code: C357
AI Vibe Coding Series

29 Review(s) | Add Your Review

What's This Course About

Automate Excel and build powerful macros with AI Vibe Coding for Excel VBA. This hands-on 2-day course teaches you how to use AI coding assistants such as Cursor, GitHub Copilot and Claude to write VBA code that automates spreadsheets and business tasks. Instead of memorising VBA syntax, you will vibe code — describing what you want in plain language and letting AI generate, explain, refactor and debug your macros while you stay in control of the logic.

Through practical projects, participants will record and write macros, work with ranges, workbooks and events, build custom functions and userforms, and automate reports and data processing — all with an AI pair programmer at their side. You will also learn to review, test and improve AI-generated code so your automations are reliable. By the end of the course, you will be able to automate Excel faster and more confidently with an effective AI vibe-coding workflow.

Course Fee

$700.00 (GST-exclusive)
$763.00 (GST-inclusive)

Course Date

Course Time

* Required Fields

Additional Note

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

Post-Course Support

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

Cancellation & Reschedule Policy

  • 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

Course Details

What You'll Learn

Topic 1 Getting Started with AI Vibe Coding for Excel VBA

  • Introduction to Excel VBA and Vibe Coding
  • Setting Up the VBA Editor and AI Coding Assistants (Cursor, GitHub Copilot, Claude)
  • Recording and Writing Your First Macro
  • Effective Prompting for VBA Code Generation

Topic 2 VBA Fundamentals with AI

  • Variables, Data Types and Operators
  • Control Flow, Loops and Procedures
  • Working with Ranges, Cells and Workbooks
  • Debugging and Explaining Code with AI

Topic 3 Automating Excel Tasks with AI

  • Automating Reports and Data Processing
  • Working with Events and Triggers
  • Building Custom Functions
  • Reviewing and Refactoring AI-Generated Code

Topic 4 Building Excel Tools and UserForms with AI

  • Designing UserForms and Interfaces
  • Connecting to Data and Other Apps
  • Testing and Error Handling
  • Packaging and Sharing Your Excel Tools

Course Info

Promotion Code

Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.

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:

TBD

Hardware: Window or Mac Laptops

Job Roles

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

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

Review

Customer Reviews (29)

wil 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 3/15/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
. (Posted on 2/28/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
Johnson is clear in explaining the difficult VBA concepts. (Posted on 5/27/2019)
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
More hands on

Tutor does not seem very knowledgeable with VBA: unable to answer some questions (Posted on 5/12/2019)
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/12/2019)

Items 16 to 20 of 29 total

per page
Page:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6

Write Your Own Review

You're reviewing: AI Vibe Coding for Excel VBA

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
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