About This Course
-
Learning Objectives
- Attain in-depth knowledge of VBA to build customisable applications.
- Become familiar with macros that automate complicated processes.
- Learn how to build a function library to gain access to new objects and functions.
Prerequisites
Microsoft Excel Macro Level 1
Target Audience
Microsoft Excel users wanting to further explore Macro Programming knowledge.
Training Outline
User Forms
Arrays
Constants and Enumerations
Class Modules
Creating Charts
Embedding Charts in a Worksheet
Pivot Table
Pivot Charts