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
- Variables
- Conditional and Logical Operators
- Controlling VBA Code
- Sub and Function
- Error Handling
- Array
- User Form