2024 Intake On-Going. Click to learn more.

Tips & Tricks In Excel Macro/VBA

About This Course

This is a customized course which covers most commonly used tips and tricks to the corporate users to create flexible Excel Macro for task automation.

Learning Objectives

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

  • code flexible range with range name feature
  • manipulate data with useful and commonly Excel VBA code
  • know how to use Timer and system date for log records
  • improve your Excel VBA performance

Prerequisites

Learners must have Intermediate knowledge & skill in Microsoft Excel Macro/VBA

 

Target Audience

Learners who need to customize and improve the Excel Macro/VBA for their Excel Macro workbook.

 

Training Outline

  1. Flexible Range Selection
  2. Tips to Manipulate Data
  3. Tips to Use Timer and System DateTime
  4. Tips to Improve Your Excel VBA Macro Performance