Advanced VBA for Project Finance

This course is aimed at Project Finance professionals with a good practical understanding of financial modelling who would like to build on their knowledge to develop the macros typically required in these models.

Overview

Course Duration: 2 Day(s)

Course Outline

Register Interest

Learning Outcomes

  • Understand the interaction between Excel and the VBA Editor and the purpose of using VBA
  • Understand VBA concepts and features, create procedures and subroutines that are robust, transparent and efficient
  • Avoid VBA ‘black boxes’ by learning how to create an interface between a workbook and the VBA Editor using Best Practice Financial Modelling principles
  • Work with variables and Excel objects
  • Learn how to automate repetitive tasks using Loops
  • Troubleshoot / debug code

Course Modules

  • Module 1: Master the basics of VBA in Excel
  • Module 2: Solve typical Project Finance Circularities (Funding, DSRA)
  • Module 3: Unlock the power of VBA to optimise debt
  • Module 4: Create change logs, scenario output tables and a break-even goal seek using VBA
  • Module 5: Learn techniques for reviewing and debugging VBA