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

Task Automation In Excel Macro/VBA (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

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

  • Using Conditional Statements and Loops to control the VBA Codes
  • Error Handling in Excel Macro
  • Creating UserForm

Prerequisites

You must have good Excel skills and understand key concepts of spreadsheets or equivalent and basic level of Excel Macro. We cover VBA Macro programming in more technically coding.

Target Audience

You must be an 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