Duration: 3 days / 22.5 hours
Time: 9am to 5.30pm
Course Code: CRS-N-0042655

Funding available for this course :

SkillsFuture Credit UTAP Broad based Funding

 

 

 

 

What Will Be Taught For This Microsoft Excel VBA Course?

This course introduces the student in 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, the students will be exposed 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 Macros
  • 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
  • Shortcut Key Dialog
  • Customizing Menu Bar and Toolbar
  • Forms Control
  • Visual Basic Editor
Module 2. VBA Environment
  • Familiarize with VBA Environment
  • Using the Edit Toolbar
  • Adding Comments
  • Use the Immediate Window
  • Use the Debug.Print
  • Use ? statement
Module 3. Working With Objects
  • Instructions, Module and Procedures
  • Object, Properties and Methods
  • Syntax Rules
  • The Object Browser
  • MsgBox function
  • InputBox function
Module 4. Variables And Data Types
  • Define Variables
  • Identify built-in Data Types
  • Create Variables
  • Declare Variables
  • Force Declaration of Variables
  • Set Option Explicit
  • User-defined constants
  • Using constants in Variables
Module 5. Operators and Decision Making
  • Relational Operators
  • Logical Operators
  • Using If statements
  • Using ElseIf statement
  • Using Select Case statement
Module 6. Loops
  • Write repetitive or looping statements
  • Do Loop, Do While, Do Until, While Wend
  • For Next loop
  • Exiting Loop
  • Nested Loop
Module 7. Subroutines and Functions
  • Overview
  • Subroutine
  • Function
  • Passing arguments
  • Passing Optional arguments
Module 8. Arrays
  • Introduction to Arrays
  • Declare Array
  • Use Option Base
  • Declare Dynamic Arrays
  • Using 2-D Arrays
  • Use Array functions
  • LBound and UBound functions
  • Erase function
  • Array Function
  • Use ParamArray
Module 9. Custom Forms Dialogs and Events
  • DialogBoxes in Excel
  • Creating UserForms
  • Understanding Form and Events Control
  • Event and Event Procedures
  • Define Event Procedures in Form
  • Workbook Events
  • Worksheet Events
Module 10. Debugging and Error Handling
  • 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)

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

Have a strong understanding of the modules and functions taught in Microsoft Excel Advanced Course.

  w/o GST w GST
Course Fee $900 $963

 


CANCELLATION/POSTPONEMENT/CHANGE of VENUE

  1. 2 to 4 weeks’ written notice from start date of training - 50% of course fee for cancellation

  2. Less than 2 weeks’ written notice from start date of training - 100% of course fees for postponement or cancellation

  3. ST Electronics (e-Services) Pte Ltd reserves the right to cancel or postpone any course or change the venue due to unforeseen circumstances.

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.