VBA Programming with MS Office

Catalog description

This course focuses on how to effectively use Microsoft Office's built-in programming language, Visual Basic for Applications (VBA), to build models, primarily in Excel. We will cover issues that facilitate the construction of robust and readily understandable models in the VBA language. Starting with basic modeling functions, the course will progress through complex modeling skills. This course assumes that you are familiar with Basic Excel operations.