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

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

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

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

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

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...
VBA macros Jun – 2 days

VBA macros
Jun – 2 days

Home > Course > VBA macros June 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...
Page 1 of 41234