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.
Book and pay online for your place below, or contact us to request an invoice.
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:
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.
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.
