About This Course
This two days course covers the fundamental skill and knowledge to create 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
Target Audience
This course is designed for experienced Excel user
Training Outline
- Understanding Excel Macro
- Your First Excel Macro Experience
- Understanding the VBE
- Overview of the Excel VBA Objects, Properties, Methods
- Application Object
- Workbook Object
- Worksheet Object
- Range Object
- MsgBox and InputBox
- Debugging Macro in Excel VBA
- Create a Simple Excel Macro Project