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.
Prerequisites: Junior Standing, minimum grade of "C-" in INFS 346.
Outcomes: By the end of this course, the student should be able to: build models using Excel built-in functions, build, customize and store Excel macros, design and build accurate, robust models with VBA, build custom VBA procedures, and create user-defined financial functions in VBA.
Prerequisites: Junior Standing, minimum grade of "C-" in INFS 346.
Outcomes: By the end of this course, the student should be able to: build models using Excel built-in functions, build, customize and store Excel macros, design and build accurate, robust models with VBA, build custom VBA procedures, and create user-defined financial functions in VBA.