Modelling Archives

‘The model says so’ is never an acceptable answer

It may well be, and very often is the case that the model is right, but you have to be able to explain what is going on

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

An introduction to checklists in modelling

"Years of knowledge, experience and organisational memory may be captured by a good checklist."

Build

Are spreadsheets killing your finance function?

The F1F9 approach (using the FAST Standard) is so simple and so effective that I found myself questioning why nothing like this had happened earlier.

Build, Review, Support

Building financial models using Agile – a quick introduction

Modelling is an inherently difficult and complex task. At F1F9 we build financial models using an Agile approach - here's why: Most guidance on managing the model build process recommends a traditional life-cycle approach of Specify, Design, Develop, Test, Deploy. When applied to most...

Build, Review

Colours speak – The language of colour

Colour is a transparent and effective way to communicate meaning within excel models.

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

In praise of charts

Smart use of quick charts can help turn a number cruncher into a chief executive

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

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...