• Home
  • Visual Basic Application (VBA) for Excel Training

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 Infotech - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from Tertiary Infotech.

Additional Information

Duration

2 months (Full Time)

Assessment

3 hours online assessment after each module

Class (No of teacher : student): 1:20

Intake

  • 3 Nov 2025 to 29 Sep 2026
  • 4 May 2026 to 26 June 2026
  • 2 Jan 2026 to 2 Mar 2026
  • 2 Mar 2026 to 27 Apr 2026

Enrolment Requirement

  • Age: 21 years old and above
  • Language Proficiency: At least C6 for GCE "O" Level English
  • Academic: At least C6 for GCE "O" Level in any 3 subjects

Graduation Requirement

  • Attendance: 75%
  • Assessment: Passed

Visual Basic Application (VBA) for Excel Training

Course Code: C357

Be the first to review this product

What's This Course About

Dive into the transformative world of Visual Basic Application (VBA) for Excel with our specialized training course. Participants will gain hands-on experience working in the Visual Basic Editor, adding and optimizing code for macros, and effectively managing code modules. The curriculum further illuminates the nuances of declaring and utilizing variables, the intricacies of variable scope, and the power of defining arrays.

Delving deeper, the course also focuses on masterfully managing workbooks and worksheets using VBA, automating repetitive tasks with loops, and employing advanced debugging techniques. Additionally, the training sharpens skills in managing cell data operations and proficiently running event procedures. Equip yourself with the expertise to harness the full potential of Excel using VBA with Tertiary Courses.

WSQ Funding

Full Fee $600.00 Before GST
GST $54.00 9% of fee
Baseline Nett $354.00 SG/PR age 21+ · 50% funded
MCES / SME Nett $234.00 SG age 40+ · 70% funded
Funding and Grant Applications

No funding is available for this course.

For WSQ funding, please checkout the details at WSQ - Software Automation with Excel VBA Programming

Course Fee

$600.00 (GST-exclusive)
$654.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 Get Started on VBA

What is VBA

Access VBA from Excel

Write Your First VBA Code

Message and Input Box

Macro Record

Topic 2 VBA Programming

Variables and Constants

Data Types and Array

Operators

Decision

Loops

Topic 3 Function and Sub Procedure

Worksheet Functions

Create Charts

Sub Procedure

Topic 4 Managing Excel Objects

Work with Excel Objects

Error Handling

Debugging

Topic 5 Events and User Forms

Events

User Forms

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

Dwight Nuwan Fonseka

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

Write Your Own Review

You're reviewing: Visual Basic Application (VBA) for Excel Training