Learn Microsoft VBA Macro Excel Training Course

SkillsFuture Eligible

UTAP

Union Training Assistance Programme

SDF

Skills Development Fund

VBA Excel Training Course: Learn Macro, Formulas, Pivot Tables, Charts, etc and automate your daily Tasks and reports easily.

FAQ

Course Start Date

02/12/2024 | 09:30 to 17:30

Week Days

Book now

07/12/2024 | 09:30 to 17:30

Weekend

Book now

13/01/2025 | 09:30 to 17:30

Week Days

Book now

07/04/2025 | 09:30 to 17:30

Week Days

Book now

10/05/2025 | 09:30 to 17:30

Weekend

Book now

11/06/2025 | 09:30 to 17:30

Week Days

Book now

Schedule

Days: 3 Days

Duration: 21 Hours

Timings: 9:30 AM - 5:30 PM

10 Anson Road, 26-08A International Plaza, Singapore 079903

Register Now

Why Choose Us

SkillsFuture Credit Eligible
Expert Local Trainers
Hands-on Training by experts
Certificate of Achievement
Free Refresh Class within 6 Month

Who Should Attend This VBA Excel Training Course Singapore

VBA excel course singapore is ideal for those professionals who are already hands-on with advanced features in Microsoft Excel

Analyst

Business professionals

Entrepreneur

Training Professionals

Student

Course Completion Requirements:

Minimum 75% attendance is required in order to complete the course and receive the course completion certificate

Entry Requirements

Above 16 years old

High School Level English

Basic internet & computer operation skills

Microsoft VBA Macro Excel Training Course

VBA (Visual Basic for Applications) is the programming language of Excel (and other Office programs), which specifically allow you to automate your repetitive tasks in Excel by writing so called macros.

Upon successful completion of this 3-day hands-on training course, students will be able to:

Record and edit macros
Use the Visual Basic Editor
Create sub and function procedures
Understand objects, properties, methods and events
Explore the Excel object hierarchy and use the Object Browser
Work with variables and understand data types
Use intrinsic functions
Work with control-of-flow structures
Design UserForms and work with controls
Control PivotTables programmatically
Use debugging tools
Add error handling to code

VBA Excel Course Description

Target Student: This course is catered for professionals who are already hands-on with advanced features in Microsoft Excel , looking to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA).

Prerequisites:

Student should be mastering of Microsoft Office Excel, including but not limited to how to create, edit, format, and print worksheets that include charts and sorted and filtered data and also advanced formulas in Excel (like ifs, vlookup, etc), pivot table, charts.

Unsure if this course is suitable for you? Take this Quick test to help you decide.

Grants available

SkillsFuture Eligible

SkillsFuture Credit: Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

UTAP

Union Training Assistance Programme

UTAP: NTUC members enjoy 50% *unfunded course fee, capped at $250 each year.

SDF

Skills Development Fund

SDF: Deductible of 2$/hours for S/PRs trainees under company sponsorship.

VBA Course Outlines

Getting Started

Introducing Visual Basic for Applications
Displaying the Developer Tab in the Ribbon
Recording a Macro
Saving a Macro-Enabled Workbook
Running a Macro
Editing a Macro in the Visual Basic Editor
Understanding the Development Environment
Using Visual Basic Help
Closing the Visual Basic Editor
Understanding Macro Security

Working With Procedures And Functions

Understanding Modules
Creating a Standard Module
Understanding Procedures
Creating a Sub Procedure
Calling Procedures
Using the Immediate Window to Call Procedures
Creating a Function Procedure
Naming Procedures
Working with the Code Editor

Understanding Objects

Understanding Objects
Navigating the Excel Object Hierarchy
Understanding Collections
Using the Object Browser
Working with Properties
Using the With Statement
Working with Methods
Creating an Event Procedure

Using Expressions, Variables, And Intrinsic Functions

Understanding Expressions and Statements
Declaring Variables
Understanding Data Types
Working with Variable Scope
Using Intrinsic Functions
Understanding Constants
Using Intrinsic Constants
Using Message Boxes
Using Input Boxes
Declaring and Using Object Variables

Controlling Program Execution

Understanding Control-of-Flow Structures
Working with Boolean Expressions
Using the If…End If Decision Structures
Using the Select Case…End Select Structure
Using the Do…Loop Structure
Using the For…To…Next Structure
Using the For Each…Next Structure
Guidelines for use of Control-of-Flow Structures

Working With Forms And Controls

Understanding UserForms
Using the Toolbox
Working with UserForm Properties, Events,
and Methods
Understanding Controls
Setting Control Properties in the Properties Window
Working with the Label Control
Working with the Text Box Control
Working with the Command Button Control
Working with the Combo Box Control
Working with the Frame Control
Working with Option Button Controls
Working with Control Appearance
Setting the Tab Order
Populating a Control
Adding Code to Controls
Launching a Form in Code

Working With The PivotTable Object

Understanding PivotTables
Creating a PivotTable Using Worksheet Data
Working with the PivotTable Objects
Working with the Pivot Fields Collection
Assigning a Macro to the Quick Access Toolbar

Debugging Code

Understanding Errors
Using Debugging Tools
Setting Breakpoints
Stepping through Code
Using Break Mode during Run mode
Determining the Value of Expressions

Handling Errors

Understanding Error Handling
Understanding VBA’s Error Trapping Options
Trapping Errors with the On Error Statement
Understanding the Err Object
Writing an Error-Handling Routine
Working with Inline Error Handling

Reviews of our students

Sarah Lah

4 months ago

Great excel course by Bee Hoon for 3 Days. Trainer was humorous and contextualised the info learnt in real life examples. Exercise files were easy to follow also.

Arun Dixit

11 months ago

I attended the excel course, our trainer Valene was really patient and well versed. The training environment was really good, I will definitely go again. Will recommend to my friends and family for sure.

Cara Chan

4 days ago

Attended WORDPRESS WEBSITE CREATION COURSE on 25 Sep 2023. Really appreciate the training made simple for beginners like myself. The trainer Mr Abhinay gave clear explanations and repeated many times to make sure we understood. Understanding how Wordpress works enabled me to navigate my company website and make updates efficiently. Unfortunately, the plug-in used by my company website was not taught in the course; which is understandable given the many different types of plug-ins available.The staffs were helpful and understanding when I was unable to log-in my singpass for attendance. It was overall an enjoyable experience to me. Snacks and beverages at the pantry was a bonus, too! Thank you, Inspizone!

Joanna

10 months ago

Thank you for the practicable courses. Lessons were conducted at a comfortable pace. Trainer Ms Mridula is knowledgeable, very helpful and encourages class participation to liven up the sessions. She also shared about how the tools can be applied in our work. Both intermediate and advanced excel courses exceeded my expectations. Thank you.

Guido Sudero

11 months ago

The course was effective for my purpose, the Teacher was clear and professional and she covered all the various aspects in an extensive and careful way. Then, the follow up they do, sending the course material to all Students is also good. Indeed a good Excel course for a beginner.

Avira Dixit

a year ago

I attended their 3 days excel training. I must say this is one of the best training places here at Singapore. They provide full training materials, you dont even need to bring your own laptop. Their course content was appropriate and examples used for explanation were relatable. The instructor was very patient and cleared all our doubts. Highly recommend!!

Leanie Lee

a year ago

I have just completed my excel levels 1 & 2. Trainer Bee Hoon is great. Her training was clear, audible & practical. A professional trainer indeed. Initially I was having some difficulties in my enrolment, but both the administrators Emma & Huyen were very helpful, patient, accommodating & efficient in their service, making it a pleasant experience I have had with InspiZone. InspiZone Highly recommended.

Wenyan Yeo (W)

7 months ago

Attended the MS Excel course (Beginner & Intermediate) on 25 & 26 Aug. Ms Koh Bee Hoon was the trainer for the above mentioned course. Ms Koh is very knowledgeable and patient, she makes sure everyone in the class understands the current topic before she moves on to the next. The lesson pace is very manageable too. After attending the course, I have learnt much more functions about MS Excel! Highly recommend this course to anyone who wish to learn more about MS Excel.

Lucia

a year ago

I have attended their MICROSOFT OFFICE EXCEL 2016 – INTERMEDIATE & ADVANCED LEVELS training. The trainer Bee Hoon is knowledgeable, patient and made online training an enjoyable hands-on experience. I would recommend the course for anyone wanting practical training, and I hope that there will be more online classes in the future.

J Quek

2 years ago

I am so glad that I had clicked on the site of Inspizone and decided to give a try on one of their courses, Master Excel Training. And I've got more than what I expected, I have done the course many years back but the trainers were never generous with their tips but Bee Hoon, a big "WOOW" she is very generous with the tips and know-how that I had never known before and she is very patient ...gosh! Fantastic trainer!! The Training Coordinator, Sophia, she was very helpful from the moment I send in my request and questions, she patiently guided me from registration, claiming my skill future till the approval and giving me the class schedule. A big thank you and great service! The school, wow!! I never have seen a school supplying such a well-stocked and premium snacks for students/trainees, the class welfare is really great and taken care of!! Thank you! I will definitely recommend Inspizone and I will keep a lookout for other courses that they have.

Katherine Ang

a year ago

I have researched on a few training centres before deciding on Inspizone. Very happy that I have chosen the right one! I have attended Microsoft Excel Intermediate & Advanced Class by Bee Hoon. She is super good, knowledgeable and clear with the online class. If you have any doubts she will also guide you patiently and ensure that you know how the functions work. If you are a beginner or you want to brush up your excel skills Bee Hoon will be my number one recommendation! 🙂 My training coordinator Emma has been very helpful towards my question too. Will definitely sign up for more courses with Inspizone!

Patricia Tong

5 years ago

Attended MS Excel 2013 Intermediate and Advanced levels. IT Trainer Ms Asha was patient and knowledgeable. Her lessons were conducted systematically. Additionally, their Project Coordinator Ms Huyen took efforts to text reminder a day before; kept the place neat and clean; and making sure refreshments were ready and adequate.

alex koh ming

3 years ago

BEST EXCEL TRAINING

Jacqueline Lee

2021-09-22

Went for a accounting course, Steven was friendly and helpful

Guido Sudero

2021-09-01

The course was effective for my purpose, the Teacher was clear and professional and she covered all the various aspects in an extensive and careful way. Then, the follow up they do, sending the course material to all Students is also good. Indeed a good Excel course for a beginner.

THIRUMALA DEVI

2021-09-15

Here i attended two courses. The Teacher is more knowledgeable person. I attend here accounts and Corporate Tax Singapore courses. really ill recommend this institute.

Lachu Gandhi

2021-09-07

Content of the course is appropriate. Trainer valene was very good and interactive. The place, course materials, the presentation and content of the material everything were clear and precise and she gave proper response to the queries raised. The place is well maintained too. Overall, a good experience and sure, I will recommend inspizone to my friends who are keen on upgrading themselves.

shengwei tan

2021-07-01

Stella is a great lecturer, the lesson taught are well orderly manner for each day which preps in beforehand and learning better.

Grace CH Ong

2021-06-11

A very useful course with laptops provided and sample datasets for our training. Training was very well-paced and clear, helpful for learning. Trainer also was happy to go around assisting when needed and managed queries well for us. Happy to have participated in a course at Inspizone 🙂

Frequently Asked Questions (FAQs)

What Excel VBA is all about?

Visual Basic for Applications (VBA) is a programming language by Microsoft for developing office applications. It helps in automation, windows API, and user-defined functions. VBA is best for manipulating the user interface features of the host applications.

VBA is super easy to learn and elevates the functionality of excel for a smooth workflow.

Why is important to learn VBA Programming?

Visual Basic for Applications (VBA) is a boon for excel users. This programing language by Microsoft eases the calculation of large data and makes complicated tasks easy for professionals. It saves a lot of time by managing data like finance and makes it super convenient to prepare reports.

Why should I go for the Excel VBA course?

Doing an Excel VBA course is beneficial in so many ways. It provides technical knowledge and opens new horizons for career growth. Doing an excel VBA course makes a person technically sound and increases the chances of bagging a high paying job.

How do I start learning VBA Programming?

VBA is a technical thing, and learning VBA takes time. To simplify the process and make it convenient, enroll in an excel VBA course. Excel macro courses are detailed and structured in a way that teaches everything from scratch and aims to master the student with all the knowledge. Research well, talk to people, analyze the curriculum and make your decision.

Is Excel VBA difficult to learn?

Excel VBA course is high in demand. Since it’s a programming language, it will take some time for anyone to get used to it. If you get the right guidance, learning material, and a credible mentor, it’s not that tough. To learn things, you have to invest time. Be consistent with your learning period, practice daily, and don’t lose focus. You’ll learn it with ease.

Frequently Asked Questions (FAQs)

What is MYOB/ABSS?

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

What is my salary potential as an Accountant specialist after completion of this MYOB certification course?

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

Why do organizations hire Accountant professionals?

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

Is this MYOB training course up to date?

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

Which course will be available for live instructor-led online classes?

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

How do I enroll in this MYOB Certification course?

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.