Overview
Students learn the Visual Basic for Applications language as well as the Excel classes and objects needed to create VBA scripts to automate Excel. Participants create procedures and functions using the VBA language and Excel objects. The PivotTable object is used to create macros that add interactivity to the standard Pivot Table. As well, debugging and error handling techniques are reviewed.
Prerequisite
Proficient knowledge of Microsoft Excel. Knowledge of PivotTables helpful but not required.
Skill Level: Advanced