2024 Intake On-Going. Click to learn more.

Task Automation In Excel Macro/VBA (Level 1)

About This Course

This two days course covers the fundamental skill and knowledge to create Excel Macros. It provides the skills and knowledge required to fully exploit the features and capabilities of Excel Macros. During in-class hands-on exercise, you will be able to enhance your Excel Macro program using the programming skills in VBA.

Learning Objectives

By the end of the course, learner will be able to:

  • record Macros
  • simplify code for application object
  • simplify code for workbook object
  • simplify code for worksheet object
  • simplify code for cell object
  • code MessageBox and Inputbox
  • create a simple Excel macro project to import data into a master table


You must have good Excel skills and understand key concepts of spreadsheets or equivalent. It is not necessary to have prior programming knowledge. We cover the basic VBA programming concepts from the very basic level.


Target Audience

You must be an Experienced Excel user who wish to automate repetitive tasks or simplify more complex tasks using Excel Macros and Visual Basic for Applications (VBA) programming language.


Training Outline

  1. Understanding Excel Macro
  2. Your First Excel Macro Experience
  3. Understanding the VBE
  4. Overview of the Excel VBA Objects, Properties, Methods
  5. Application Object
  6. Workbook Object
  7. Worksheet Object
  8. Range Object
  9. MsgBox and InputBox
  10. Debugging Macro in Excel VBA
  11. Create a Simple Excel Macro Project