VBA: What the FAST modeller needs to know

What is this course?

VBA: what the FAST modeller needs to know is a short online course on how you might expect to see macros used in FAST financial models. It is designed for those who work with financial models either as builders or reviewers.

FAST modelling uses macros and Visual Basic for Applications (“VBA”) as a last resort. That’s because VBA lacks transparency: even before you can review a macro, you need to know where it is stored and something about the environment in which it sits. It is like opening the bonnet on a car – what is underneath is not necessarily designed with the casual observer in mind. But the FAST modeller needs to have a working knowledge of VBA since there are instances – often on the grounds of productivity and efficiency – where macros have a role to play.

What you will learn?

There is lots of information available for free on the internet, but little of it is focused on the FAST modeller.

This course is an introduction to VBA that leads to the design and construction of two commonly used macros:

  • a goal seek routine to set an input so that it meets a condition; and
  • a circuit breaker routine to remove a circularity from a model.

On completing the course and its assessments, you will be able to describe the main features of VBA and the environment in which macro coding sits. You will be able to take existing macro coding and use it to build your own macros; you will also be able to investigate how you might build your own coding from scratch.

Who should take this course?

Our VBA for FAST modellers course is designed for professionals who work with financial models either as
builders or reviewers.

Our instructors have designed this course for those who have some degree of confidence in working with financial models and need a quick primer when it comes to VBA.

Book your course

Change currency
Date
Format
Location
Duration
Instructor
Price
n/a
Online
n/a
2 hours
Andrew Berkley
£49

Course agenda

Online modules:
  • Setting up the macro environment
  • Running a macro
  • Visual Basic Editor
  • Assessment – constructing a macro
  • Name ranges in macros
  • Running a goal seek macro
  • Amending the goal seek macro
  • Editing code
  • Circuit breakers
  • Assessment – circuit breakers
  • Inspecting a macro
  • Assessment – inspecting a macro
  • Running a macro using buttons
Find out more: