Blog

12 Excel functions financial modellers should know

12 commonly used Excel functions every financial modeller should know

That’s because, when it comes to formulas, we aim for simplicity and readability. Complex functions with poor audit trails (I’m thinking of OFFSET, for example) are less useful when your primary objective is transparency. Here are 12 functions that we use again and again in building...

Build, Review, Support, Training

F1F9: a local presence in Dubai, GCC and beyond

We are pleased to confirm our presence in the Gulf with a team based in Dubai. Our full range of services will be available across the region: training, model build, and model review / risk management. The Dubai office will be led by Omar Shaker who has recently joined our senior team.

Build, Support, Training

Average Internal Rate of Return (AIRR)

An introduction by F1F9: We were approached by Thierry Renard and Carlo Alberto Magni and were intrigued by what they had to say: a new approach to calculating an internal rate of return. What's more, they were illustrating the application of the Average Internal Rate of Return ("AIRR") using Excel...

Build, Review, Support, Training

Monitor parts of your Excel workbook without leaving your current view

How do I know what is going on in my kitchen when I am upstairs in my bedroom? If that's a question that is a concern to you, then you might have considered some sort of surveillance device. A web cam, perhaps. Such a device exists in Excel – designed to answer the question: "how do I know...

Build, Review, Support, Training

Use Excel – and be confident that you are using it well

It’s always interesting to pass the time with a fellow traveller on a long-haul flight. In this instance, I was on a regular trip to New Delhi to visit F1F9’s head office. My neighbour was the head of internal audit for a FTSE 100 company. We talked about Excel, of course, and how a business...

Build, Review, Support, Training

Additional keyboard shortcuts to increase your productivity

We are launching a new version of F1F9’s keyboard shortcuts. You will find them available to download in an Excel workbook just below.The shortcuts are stored as macros in the workbook. On opening the workbook, you may need to click on “Enable Content” or “Enable Macros” to make sure things run properly.

Build, Review, Support

Standardised Modelling – Behavioural change is always hard

“If you want to make enemies, try to change something” Woodrow Wilson Despite what we modelling geeks might like to think, people are both rational and emotional. Which makes standardised modelling practices difficult to implement. Our ebook 'How to Standardise Modelling' helps modellers...

Build, Review, Support, Training

How to Model Balances in Excel

There are two basic types of line item in financial models – flows and balances. Balances are amounts at a point in time. Balances can be financial or non financial. Every balance has similar properties. This blog explains what those properties are, and gives a standard model component that...

Build, Review, Support, Training

Amnesia – 10 Signs Spreadsheets are Killing your Finance Function

The following text is taken from our ebook - 10 signs spreadsheets are killing your finance function: #4 Amnesia SYMPTOMS: Last minute panic buying of birthday presents. Missed gym appointments. You hear ‘aren’t you meant to be somewhere else?’ more often than you’d like. Family...

Build, Review, Support, Training

Managing Modelling: Embrace an open and honest culture

Errors will happen. It is an unfortunate fact of life, whenever humans are involved with complex data manipulation and modelling, errors occur. A financial modelling manager needs to create an environment where any member of the modelling team can feel comfortable notifying them as soon as an...

Build, Review, Support, Training

Business Analysis Lifecycle ebook: Conceptual Modelling

We have taught analysts from hundreds of companies to build financial models. Financial modelling proficiency requires skills that take time to acquire, develop and perfect. Sometimes the difficulties students have are related to how to build their model. More often, difficulties relate to what...

Build, Review, Support, Training

Financial modelling: start with the end in mind

"The habit of beginning a process of construction with a clear understanding of the end product can be highly beneficial when building financial models"

Build, Review, Support, Training

New ebook on collaborative financial modelling

The article below is taken from our new ebook: Managing Modelling - How to run an effective modelling team, it's available for you to download free of charge and with no form-filling. Financial modelling should be a collaborative team-based activity, not an individual activity. Building team...

Blog

Subscribe to our blog