“[The trainer] was open to many questions and went out of his way to fit everything in. The building of the 3 statement model was very helpful.”
Ish
– following his
Excel VBA macros
FTA’s financial modelling course training includes coverage of VBA macros.
If you’ve ever found yourself regularly performing some kind of repetitive task in Excel, VBA could help you.
With VBA macros you can automate your routines in Excel, replaying them automatically at the press of a button.
VBA macros allow you to speed up your work and your analysis.
Adding across columns
In a recent post we were looking at how failing on some of the modelling basics can end up being a bit of a giveaway. In that case we were looking at how a minor formatting inconsistency (and inattention to detail) in the outputs sheet, something that we quickly...
A circular reference circuit breaker
If we were to list out our guidelines for best-practice modelling here (you get it on our financial modelling course) towards the top we’d have to put “No circular references” and “No macros”. But even we think it’s fun, and perhaps...
Unleash the power of Excel with VBA macros
Here you can see the reviews a team from an international asset management company (based in the West End of London) gave the VBA macros course. Finance staff found themselves continuously having to rearrange source spreadsheets to fit internal reporting demands. We...
Excel VBA macros
Feb – 2 days
Home > Course > Excel VBA macros Find out more about theVBA macros course This course helps you take your spreadsheets to the next level, discovering the power of the VBA code that lies behind Excel. Automate routines and turbocharge... Excel VBA macros
Oct – 2 days
Home > Course > Excel VBA macros Oct – 2 days Find out more about theVBA macros course This course helps you take your spreadsheets to the next level, discovering the power of the VBA code that lies behind Excel. Automate...