Model Construction Skills
Free Course
Welcome to this introductory course on model construction skills. On completing the course, you will have a good awareness of the basic construction techniques required to build a financial model that is flexible, appropriate, structured and transparent.
Book Your Course
| Date | Format | Location | Duration | Instructor | Price | |
|---|---|---|---|---|---|---|
| As requested | Video-based | As requested | As requested | Any | Free | Book Free Course |
Our Clients
Course Content
What will I learn?
Welcome to this introductory course on model construction skills. On completing the course, you will have a good awareness of the basic construction techniques required to build a financial model that is flexible, appropriate, structured and transparent.
In all of our teaching we will be following the FAST Standard – a freely available and detailed guide to designing and constructing financial models. For more details on the FAST Standard, go to: www.fast-standard.org
Course Topics
- F1F9 productivity macros
- Spaces in formulas
- Calculation blocks
- Copying calculation blocks
- Row anchoring
- Navigating using links
- Daisy chains
- Copying links
- Placeholders
- Placeholder macro
- Timing flags
- Cross worksheet links
- Paste links forward
- Advanced productivity
- Introduction to modelling balances
- Counterflows
- Temp sheet
- Quick charts
- Model construction skills - assessment
- Ten things to remember
Meet Our Instructors
John Dimberline
John has 18+ years of experience and has led advisory teams on many complex projects supporting both public sector procurers, private sector bidders and corporates. Formerly head of financial modelling at Grant Thornton, John leads the senior management team at F1F9.
Andrew Berkley
With a background in business education and financial advisory work, Andrew leads training delivery at F1F9. Andrew has delivered financial modelling courses to numerous institutions including European Bank of Reconstruction and Development, Deloitte, KPMG, Grant Thornton and Siemens.
Omar Shaker
Omar is a highly experienced financial modeller having spent 15+ years building FAST compliant and best practice models in the project finance advisory (debt and equity) sector. He has worked on some of the largest transactions globally with an aggregate value exceeding USD 20bn. He is fluent in Arabic both written and spoken.
Morten Siersted
Morten founded F1F9 in 1999. He has played a key role in developing the FAST Standard, including setting up the FAST Standard Organisation in 2011.
Client Reviews
S. C. Invest NL
I liked the format and the fact that you are building up the model. i think the course was most helpful when you needed to think for yourself and build a part – perhaps more time spent doing this would have been good.
S. V.EBRD
Thanks a lot for the course, it was very useful and well structured. The instructor explained it awesome!
Jord W.
Excellent training! well thought program, really guiding you through the process of setting a financial model! I can really recommend it to everybody who is interested in following a financial modelling course.
Maryam Ahmed Network Rail
Great course- has given me a solid foundation to understand and build basic models within my role. Pacing is good and found the tutor’s instructions to be very straighforward to follow. Highly informative and will definitely consider coming back for the next level once I have put some of the skills learnt on this course into practice. Thank you
Charles Serinet SUEZ
Very useful to understand the impact of changes in revenue, gearing, DSCR on CFADS, Average DSCR, Div and Equity IRR. Very interesting as well to build step by step the balance sheet, P&L and CF to understand the connections between each statements. The track and resources tabs are really useful too.
Michael Leonhart KPN
The structure of the course was good and gave a good insight in how to build the consistent model. Sometimes, it was more about doing rather than really understanding why, so maybe a little more time spend on that topic would be nice. In general I learned a lot about the various shortcuts an modelling in general.
Mthandeni Vilakazi, AIIM
Specifically found the shortcuts and best-practice principles on model construction particularly helpful in improving productivity and efficiency. I also appreciated the use of a tracking sheet, as well as the time taken to explore alternative functions and approaches to understand their limitations.
Agie Turowska, Network Rail
The practical tools were great and will be very handy to pass on and help my colleagues too. The format was very good and easy to follow. I liked that we had two instructors helping when anyone got stuck while the rest were able to carry on.
Anonymous
Andrew was comprehensive, friendly and attentive. He managed the group very well, catered to all learning speeds, and ensured everyone’s questions were answered without disrupting the flow of the course.
Mthandeni Vilakazi, AIIM
The shortcuts and model construction best practices were particularly helpful in improving my productivity and efficiency. Andrew and Judith were phenomenal, the pace of teaching was excellent and very accommodating.
Get In Touch
Are you or your team looking to increase their financial modelling skills? Are you interested in team-based training focused on best practice and standardised approaches? Are you hoping to build up your own skills and expertise?
Our financial modelling instructors would be pleased to hear from you…