April 2024 Intake On-Going. Click to learn more.

Excel Macro Level 2

About This Course

This two days course covers the VBA programming more complex 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

-

Prerequisites

Good Excel skills and understand key concepts of spreadsheets or equivalent and basic level of Excel Macro.

Target Audience

Experienced Excel user who wish to do more complex tasks using Excel Macros and Visual Basic for Applications (VBA) programming language

Training Outline

  1.  Variables
  2. Conditional and Logical Operators
  3. Controlling VBA Code
  4. Sub and Function
  5. Error Handling
  6. Array
  7. User Form