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
- Flexible Range Selection
- Tips to Manipulate Data
- Tips to Use Timer and System DateTime
- Tips to Improve Your Excel VBA Macro Performance