Microsoft VBA Macro Excel Training Course Singapore
UTAP
Union Training Assistance Programme
3 DAYS
Course Days
21 HOURS
Course Duration
9:30 AM - 5:30PM
Course Timings
VENUE
10 Anson Road, 26-08A International Plaza, Singapore 079903
Course Start Date
Microsoft VBA Macro Excel Training Course
VBA (Visual Basic for Applications) is the programming language built into Excel (and other Microsoft Office programs). It lets you automate repetitive tasks by writing simple programs called macros, saving you time and effort when working with Excel.
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.
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.
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
Turn insights into strategy
Business professionals
Drive smarter decisions
Entrepreneur
Innovate with AI power
Training Professionals
Upskill the future workforce
Student
Kickstart your AI journey
Entry Requirements
Above 16 years old
High School Level English
Basic internet & computer operation skills
Course Completion Requirements
Minimum 75% attendance is required in order to complete the course and receive the course completion certificate
Grants available
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
- 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
- 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
See how MOCD Studio’s courses help our students grow and succeed
Top Most Related Courses
Join Advanced Excel Training in Singapore
Join our Advanced Excel Course in Singapore to learn powerful tools like VLOOKUP, HLOOKUP, data consolidation, protecting your worksheets and...
Read More
Microsoft Excel Intermediate Training Course
UTAP Union Training Assistance Programme Quick Enquiry Registration 1 DAYS Course Days 7 HOURS Course Duration 9:30 AM – 5:30PM...
Read More
Learn Basic Excel Course in Singapore
UTAP Union Training Assistance Programme Quick Enquiry Registration 1 DAYS Course Days 7 HOURS Course Duration 9:30 AM – 5:30PM...
Read More
Microsoft Master Excel Course in Singapore
UTAP NTUC members SkillsFuture Eligible Quick Enquiry Registration 3 DAYS Course Days 21 HOURS Course Duration 9:30 AM – 5:30PM...
Read More
Best Microsoft Excel Dashboards Training Course in Singapore
UTAP NTUC Members SkillsFuture Eligible Quick Enquiry Registration 2 DAYS Course Days 14 HOURS Course Duration 9:30 AM – 5:30PM...
Read MoreFAQ for VBA Excel Training Course Singapore
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?
The course typically lasts 3 days, with both weekday and weekend schedules available
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.
ADDITIONAL SUPPORT
For Company
* Eligible companies can reimburse up to 90% of the payable amount via SFECFor Self-sponsor
* Singaporean can offset the payable amount via SkillsFuture Credit (Except Mid Career Credit) and/or PSEA * NTUC Union members can reimburse of up to 50% of the unfunded fee under UTAP Enjoy up to $250 UTAP support. More info: UTAP
Note: minimum 75% attendance & passing all the assessment are required for WSQ subsidy deduction.
Address
10 Anson Road,
26-08A International Plaza
Singapore 079903
Top Trending Courses
Terms and Conditions
Accounting & Non Finance Course
Programming course
Soft Skills Course
Creative Course
Project Management Course
Soft Skills Course
LCCI Certification Course
Microsoft Excel Course
Online Marketing Course
Website Design Course