As innovation in finance develops and transactions become more complex they require a level of analysis that surpasses the ability of a standard spreadsheet program and necessitate the implementation of computer programming. The most effective way of harnessing the power of programming for finance is to learn Visual Basic Applications (VBA) within the context of relevant problems.
This course will take participants through the basics of working in VBA’s integrated development environment to ultimately writing intermediate level code that can be used to amortize thousands of loans or run powerful simulations.
- Banking Staff: Analyst, Associates, Vice Presidents, Directors, Support Staff
- Understand the basics of object oriented programming and how the Visual Basic Applications (VBA) language is integrated within Excel.
- Understand basic to intermediate programming techniques specifically related to finance: scenario management for cash flow models, optimization techniques, and administrative automation.
- Learn automated calculation and model management through a dashboard type control.
Experience in finance and basic Excel. Ideally, participants will have completed our Financial Modeling, Forecasting and Valuation workshop prior to this class.
If students have time, they may want to read the early chapters of John Walkenbach’s: Power Programming in VBA (Wiley)