Following DORSCON Orange status, IT Enabler has implemented MOH work from home measure. Our customer service team is currently working from home. For any enquiries, please call or email us.

+Android Programming Course
+Apple iOS Apps Development
+SQL Scripting
+MS SQL Server 2012
- MS SQL Server 2012 Database Administration
- MS SQL Server 2012 Database Querying

+Oracle Database SQL
- Oracle Certified SQL Expert

+VBA Excel / Access / Word
+Web Design & Ecommerce
+Web Development &

- SQL Scripting
- Adv SQL Scripting
- Javascript
- HTML5 with JavaScript and CSS3
+Microsoft Infrastructure Certification

CompTIA Courses


Basic Networking & IC3 Courses

Register Courses at IT Enabler
Home > Course List > VBA for Excel 2010/2013/2016
VBA Excel Course Singapore - VBA Excel 2013/2016 (NICF - VBA Excel)

Course Objective:

This 3-day course guides participants in using some of Excel’s commonly used formulas. Participant also learns how to simplify your work in the Excel environment by automating many of the repetitive tasks that are part of database development. In this course, participant will apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks in Excel 2010/2013/2016 environment.

Participants will be proficient in using VBA to create macros for automating repetitive tasks in Excel 2010/2013/2016.

Participants looking to gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. In addition, participants who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Prior knowledge in Excel 2003/2007/2010 and especially suitable for participants who had attended Excel 2007/2010/2013 Intermediate and Advance course.

Certificate Of Attendance:
Certificate Of Attendance will be awarded to participants completing the course achieving minimum 75% attendance.

Training Duration:

Full-time: 3 Weekdays / 3 Sats             
Time : 9.00am - 6.00pm (24hrs)

Course is eligible for SDF Training Grant and Absentee Payroll.
Self-sponsored trainees may apply for SkillsFuture Credit Claim.
Terms and conditions apply

Course Outline:

1. Getting Started with VBA Excel
• Introducing Visual Basic for Applications
• Displaying the Developer Tab on 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 Visual Basic Editor
• Understanding Macro Security

2. 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 Procedures
• Naming Procedures
• Working with the Code Editor

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

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

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

6. Working with Forms and Controls
• Understanding UserForms
• Using the Toolbox
• Working with the UserForm Properties, Events, and Methods
• Understanding Controls
• Setting Control Properties in the Properties Window
• Working with the Label Control
• Working with the TextBox 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

7. Debugging Code
• Understanding Errors
• Using Debugging Tools
• Setting Breakpoints
• Stepping through Code
• Using Break Mode during Run mode
• Determining the value of Expressions

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

9. VBA Macros Security and Protection in Excel
• Password Protecting the code
• Hiding and very hiding Worksheets
• Protecting the Sheet
• Protecting the Workbook
• Password Protecting a single VBA Procedure

Al fees subjec to GST 7%.
Course Fees (Applicable to Non-SDF/Foreigner)
Course Title Normal Course Fees Promotional Course
Fees valid till
Promo Course Fees w GST
NICF - VBA ExcelS$799.00S$650.00S$695.50
Registration FeeS$30.00S$30.00S$32.10
Total FeeS$829.00S$680.00S$727.60

Government Funding
Course is eligble for SDF Training Grant & Absentee Payroll from SSG. 
Self-Sponsored trainee may offset course fee payable using their SkillsFuture Credit Claim or/& PSEA (subject to available balance in trainee's account). 
Terms and conditions apply. 

SDF Course Title : VBA Excel (SF)
Course Ref No. : CRS-Q-0032182-ICT

WSQ Funding Course Fees
WSQ Funding
Singapore Citizens & Singapore PRs
Total Fee
Incl Regn Fee
SDF Training
Excl GST 7%
Incl GST 7%
SME Company S$680.00S$585.00S$95.00S$142.60
Non-SME CompanyS$680.00S$325.00S$355.00S$402.60
Mid-Career Enhanced Scheme (MCES)
- Singaporean, 40 yrs & above
Note: * - SkillsFuture Credit Claims or/and PSEA may be used to offset the course fees.

Course Title   Venue Register Online
Course Mode
Start Date
End Date
NICF - VBA ExcelSingaporeRegisterFULL-TIME19-May-202121-May-20219:00-6:00PM 
NICF - VBA ExcelSingaporeRegisterFULL-TIME23-Jun-202125-Jun-20219:00-6:00PM 
NICF - VBA ExcelSingaporeRegisterFULL-TIME14-Jul-202116-Jul-20219:00-6:00PM 
NICF - VBA ExcelSingaporeRegisterFULL-TIME2-Aug-20214-Aug-20219:00-6:00PM 
NICF - VBA ExcelSingaporeRegisterFULL-TIME1-Sep-20213-Sep-20219:00-6:00PM 
NICF - VBA ExcelSingaporeRegisterFULL-TIME11-Oct-202113-Oct-20219:00-6:00PM 
NICF - VBA ExcelSingaporeRegisterFULL-TIME17-Nov-202119-Nov-20219:00-6:00PM 
NICF - VBA ExcelSingaporeRegisterFULL-TIME8-Dec-202110-Dec-20219:00-6:00PM 
NICF - VBA ExcelSingaporeRegisterSAT10-Jul-202124-Jul-20219:00-6:00PM 
NICF - VBA ExcelSingaporeRegisterSAT9-Oct-202123-Oct-20219:00-6:00PM 

Download VBA Excel Course Brochure
Download Advanced VBA Excel Course Brochure (Contact Customer Service @ 6333 4843)