2024 Intake On-Going. Click to learn more.

Excel Macro 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



Good Excel skills and understand key concepts of spreadsheets

Target Audience

This course is designed for experienced Excel user

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