Resources
Explore our ebooks, reports, free online courses and more for information about our approach to financial modelling. You'll find plenty of insights that we offer in the spirit of sharing our knowledge as widely as we can - and we'll add more content as soon as it's ready.
Free Course
Excel Proficiency Skills
Join thousands of people who use our Excel Proficiency Skills online course to help them prepare for an F1F9 classroom course. Our 16 short videos will help you practise your skills as you work towards being a fluent Excel user.
Free Course
31 days to better financial modelling
In around 10 minutes per day for 1 month, this free online financial modelling course will teach you practical and highly effective new modelling skills (based on the FAST Standard)
Paid Course
FAST Fundamentals
This course is designed for people who have made good use of all our free resources. It is the next step on the journey to mastering a rigorous, structured and transparent approach to modelling in Excel using the FAST Standard.
Paid Course
Encyclopedia of FAST modelling
We’ve designed Encyclopedia of FAST Modelling for those who want get into the detail of how best to use Excel in designing and constructing financial models using the FAST Standard.
There is a lot to look at already – and the bank of resources will be ever expanding.
There is a lot to look at already – and the bank of resources will be ever expanding.
Paid Course
VBA: What the FAST modeller needs to know
This course is an introduction to VBA that leads to the design and construction of two commonly used macros:
a goal seek routine to set an input so that it meets a condition; and
a circuit breaker routine to remove a circularity from a model.
a goal seek routine to set an input so that it meets a condition; and
a circuit breaker routine to remove a circularity from a model.
F1F9's example model
There’s no shortage of blogs, articles and opinion pieces on how we should go about building a financial model, but they only really scratch the surface and need some imagination to go from principles to practicality. That’s why we’ve put together an example model to share with anyone who’s interested in taking a look.
White Paper
What skills must university students learn?
In evaluating job candidates, employers are all about skills: all skills - both academic skills and professional trade-craft. They are influenced less by the “knowledge” imparted by a specific degree. John Richter considers how we might do a better job of equipping graduates with skills required in the workplace.
Financial modelling guide
Technical notes on Escalation
At one level, financial modelling boils down to just two challenges: first, placing values correctly in time, and secondly, adjusting these values correctly for ‘the passage of time’. Download our Escalation notes to learn more - no form-filling required.
Ebook
Managing Modelling
How to run an effective modelling team. 'Managing Modelling' uses real examples of how to run an effective modelling team with case studies from F1F9 customers and partners.
Ebook
The oil and gas modelling checklist
This ebook will help you scope out the model build requirements for an Oil and Gas project.
Ebook
10 Signs that spreadsheets are killing your finance function
What are the symptoms of a serious spreadsheet infection?
Ebook
How to standardise modelling
Professionalising modelling in your organisation is not just about running a training course - it's about change management, and that can be hard work.
Ebook
How to build & use tornado charts in Excel
Is your forecast precise enough to make a confident decision?
Ebook
Essential Model Optimisation
A large part of project finance modelling is about finding a financial solution that works. The optimisation process is an important part of finding that solution.
Ebook
10 principles of Agile financial modelling
When applied to most financial modelling assignments a traditional lifecycle approach to financial model build doesn't work, this ebook will explain why.
Ebook
A practical guide to opex modelling in oil and gas
This guide will help you understand the types of opex that you are likely to encounter in oil and gas projects.
Ebook
Business Analysis Lifecycle
Your model exists to answer business questions. It is not an end in itself. This ebook defines the role of modelling in decision making.
Ebook
Dirty Dozen: 12 Modelling Horror Stories
It has been reported that 88% of spreadsheets have some sort of error in them. Here is our list of the top 12 financial modelling horror stories.
Ebook
CAPEX Modelling in Oil and Gas
In this ebook we explain the origin and application of the S-curve, and provide you with flexible worked example modules in Excel, built to the FAST Standard.
Ebook
Why Fixed Price Modelling Contracts Are Bad For Everyone
Although there are many good reasons for clients to request fixed price arrangements, they are bad news for clients and for suppliers.
White Paper
Valuation Modelling Standards
Guidelines for spreadsheet modelling in the mining industry - by Dennis Cowen