Excel 2016 Power Programming With Vba -

: Utilizing the Visual Basic Editor (accessed via Alt + F11 ) to write, debug, and manage code modules.

: Understanding how to manipulate Excel as a collection of objects (Workbooks, Worksheets, Ranges) using their properties (adjectives) and methods (verbs). Excel 2016 Power Programming with VBA

This report examines the core concepts of , a subject largely defined by the authoritative Wiley resource authored by Michael Alexander and Dick Kusleika. 1. Executive Summary : Utilizing the Visual Basic Editor (accessed via

: Moving beyond the Macro Recorder to write dynamic Sub procedures and custom Function procedures (User-Defined Functions). advanced users must master:

Based on standard programming curriculum , advanced users must master: