This course introduces you to Excel Macro programming using Microsoft's Visual Basic for Applications (VBA). The overall focus of this course is to teach you proper Visual Basic programming techniques along with an understanding of Excel's object structure. Other topics in this course include recording macros, programming basics, proper variable declaration, Visual Basic functions, control structure use, looping, and UserForm creation. The final section deals with the debugging tools included in the Microsoft VBA editor and methods on how to effectively use them.

Understanding the Excel Object Model, Creating Recorded Macros, Understanding the Visual Basic Editor, Understanding Programming Basics, Using Visual Basic Functions, Working with Control Structures, Creating UserForms, Debugging Your Macros