F1F9 has designed additional macro shortcuts to increase a modeller’s productivity. You do not have to use them to build a financial model, but many of our training clients tell us that they find them extremely useful. For example: Ctr ...

In Praise of Charts Share: In Praise of Charts A quick chart in Excel is a wonderful thing: highlight some data, press F11, and sit back. Enjoy the feeling of fingers off keyboard. For a brief moment while considering that ...

How skills-based training can transform financial modelling
It’s frustrating to struggle at something only to discover that, after much hard work, there was an easier way. That’s why people seek out formal training courses in financial modelling. I frequently ...

Most financial modellers create graphs to visualise data or to check trends. While building finance models, a good modeller will keep asking themselves whether their results are looking sensible. A good financial modeller will regularly chart line items and analys ...

Most financial modellers create graphs to visualise data or to check trends. While building finance models, a good modeller will keep asking themselves whether their results are looking sensible. A good financial modeller will regularly chart line items and analys ...

Of 450+ functions available in Excel, we commonly use no more than 12 when building financial models.
That’s because, when it comes to formulas, we aim for simplicity and readability.

Complex functions with poor audit trails (I’m thinking of ...