VBA: what the FAST modeller needs to know

What the FAST modeller needs to know

Author:

Andrew Berkley

Published:

08 Mar 2017

Comments:

0 Comments

Category:

We are pleased to launch a new online course. It is called VBA: what the FAST modeller needs to know.

Need to know only

There is a lot to learn about macros, Visual Basic for Applications (“VBA”) and programming in Excel, but if you are building financial models using the FAST Standard then what do you need to know?

We think the answer is: a small number of carefully chosen techniques. That’s because the philosophy behind modelling with the FAST Standard is to work with complex techniques as a last resort – and then with great care.

There are plenty of financial models that rely on iterative processes in order to derive an answer. Regular reporting models that need to be updated for this month’s actuals, for example. Or a funding model that is subject to the rigours of model optimisation.

It is useful to have a basic understanding of VBA. And carefully designed and constructed macros can very helpful in converting mechanical and repetitive processes into something that can be completed quickly and with little user effort.

Defence against the dark arts

Macros are immensely powerful and can be a force for good. They also, by their nature, lack transparency, encourage complexity and are difficult for the casual observer to review. These combined characteristics cause some to describe VBA and macros as “the dark arts”.

And that is even before poorly designed and constructed macros start misbehaving and generating errors.

The FAST modeller needs to be prepared if macros and VBA are to be welcomed, understood and properly evaluated. “VBA: what the FAST Modeller needs to know” is a short and concentrated course designed to help the FAST modeller in their preparations.

The price is 49 GBP (discounted to 29 GBP for the launch week).



Sign up


The FAST Modeller

With 20,000+ people signed up to F1F9’s “31 days to better financial modelling” online course, we are seeing a strong desire for individuals and organisations to build up a solid skill base when it comes to financial modelling in Excel. It is what we call “business tradecraft” – a non-sector specific collection of understanding, skills and applied knowledge that today’s professional should have.

If you would like to join F1F9’s online learning platform then we’d be pleased to hear from you. Check out our courses using this link or email alex.arnold@f1f9.com.

Andrew Berkley
Do you have a better solution than this? I’m curious to know. If you do, or if you have any thoughts on my blog, join the discussion below.If you’d like to receive more information on data visualisation, please sign up to the topic-specific mailing list.
Andrew Berkley
Andrew has spent one half of his career as a finance professional and the other half in learning and development running finance-based training courses. Andrew leads the senior team at F1F9. He has been with F1F9 since 2013.