Duration: 3 days / 24 hours
Time: 9am to 6pm
Course Code: CRS-Q-0041093-ICT

Funding available for this course:

Enhanced Training Support for SMEs NICF-SF SkillsFuture Credit SkillsFuture Mid-Career Enhanced Subsidy

 

What Will Be Taught For This Microsoft Excel VBA Course?

This course introduce concepts of automating and customizing the different processes in Excel through VBA coding. It uses the various Excel Objects Models to manipulate and control the applications, worksheets and ranges. Furthermore, participants will be introduced to the different programming constructs and techniques in handling data from the worksheet. Through this MS Excel VBA course, the trainee will also learn how to use Events in Excel, VBA Arrays, and creating useful data forms.

 

Module 1:

  • Introduction to development tools and methodologies

Module 2: Discover Macro Security Level

  • Define a Macro Title
  • Define the relationship between Macros and VBA
  • Open Workbooks containing Macros
  • Set Macros security level
  • Enable and disable Macros
  • Record and store a Macro
  • Specify Macro location
  • Run a Macro
  • Macro Dialog Box

Module 3: Programming with VBA

  • Familiarize with VBA Environment
  • Using the Edit Toolbar
  • Adding Comments
  • Use the Immediate Window
  • Use the Debug.Print
  • Use ? statement
  • Instructions, Module and Procedures
  • Object, Properties and Methods
  • Syntax Rules
  • The Object Browser
  • Variables And Data Types
  • Operators and Decision Making commands
  • Write repetitive or looping statements
  • Introduction to Arrays
  • Declare Array
  • Use Option Base

Module 4: Create User Defined Function

  • Overview
  • Subroutine
  • Function
  • Passing arguments

Module 5: Perform Testing and Debugging

  • Testing Procedure
  • Stopping a Procedure
  • Stepping through a VBA Procedure
  • Insert Breakpoint
  • Stop statement
  • Add Watch expression
  • Debug Windows
  • Bookmarks
  • On Error statement (Trapping Errors)

Module 6: Create Your User Form Application

  • Creating UserForm
  • Understanding Form and Events Control
  • Event and Event Procedures

Assessment Format & Duration (only applicable for learner taking SF grant)

Assessment Duration
Written Assessment 60 mins
Practical Performance 60 mins
Total 120 mins
 

 

Who Should Attend This Microsoft Excel VBA Training?

  • Perfect for experienced Microsoft Office Excel users who wish to expand their skill set for a larger scope of analyst roles.
  • Anyone who may want to automate repetitive tasks or simplify complex tasks using the VBA programming language.

Pre-requisite

A working knowledge of Microsoft Office Excel (such as understanding cell referencing, formula [SUM, AVERAGE, COUNT, IF) would be required.

 

  w/o GST w GST
Full Course Fee $1,500 $1,605
Singapore Citizen & PR aged ≥ 21 years $1,140 $1,245
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$300 $405

 

  w/o GST w GST
Full Course Fee $1,500 $1,605
Singapore Citizen & PR aged ≥ 21 years $1,140 $1,245
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$300 $405

 

  w/o GST w GST
Full Course Fee $1,500 $1,605
Singapore Citizen & PR aged ≥ 21 years $300 $405
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$300 $405

 


Trainee shall be bound by the Terms and Conditions of any applicable funding scheme.

Please ensure that you have read our Terms and Conditions before submitting the enrolment form.







Please click on the course date to enrol.


  • CL: Classroom Learning
  • VILT: Virtual Instructor-Led Training
  • GTR: Guaranteed To Run
  • Sat: Saturday
  • Wkn: Weekend
Note: Courses are conducted via classroom unless stated otherwise beside the course dates.