Self-Paced Financial Modelling Video Courses

Expert & Certified Financial Modelling courses for best-in-class modelling

Our training courses maximise modelling capability for individuals and organisations. F1F9 instructors with extensive real-world experience run intensive courses that are available to you in pre-recorded videos in which you can progress through at your own pace.

Step into one of our financial modelling courses with Andrew Berkley and John Dimberline as your guides. In just 5 minutes, they describe the immersive nature of our hands-on training - whether classroom-based or live-online.

Which course is right for you?

Best Practice Financial Modelling

In-house
Classroom-based
Video-based
Live online
Working through a business acquisition case study, you will forecast the 3 primary financial statements and determine the equity valuation from the present value of forecast dividends. You will also cover debt financing, inflation, depreciation and taxation.
Book now from GBP 395
(USD, EUR and AED also available)

Project Finance Modelling

In-house
Classroom-based
Video-based
Live online
Learn to build a financial model covering the entire life of the project – from the beginning of construction to the end of operations – which meets the requirements of 3 key stakeholders: customer, debt investor and equity investor.
Book now from GBP 595
(USD, EUR and AED also available)

Financial Modelling For Renewables

In-house
Classroom-based
Video-based
Live online
This course uses the construction, financing and operation of a wind farm as a backdrop against which practical modelling skills can be developed and transferred to any renewables-based project. It focusses on the modelling challenges that renewables projects often present: seasonality and a preference for monthly models from start to finish, modelling with P90 and P50 forecasts, modelling cash sweeps.
Book now from GBP 1,295
(USD, EUR and AED also available)

Working with Financial Models

In-house
Classroom-based
Video-based
Live online
Working with Financial Models teaches the principles and skills needed to work safely and effectively with financial models.  It's designed for anyone who is required to review, operate and test financial models that they have not built themselves.
Book now from GBP 795
(USD, EUR and AED also available)

Live Online - Financial Modelling Courses

In-house
Classroom-based
Video-based
Live online
We also offer Live-Online training courses - maximise modelling capability for individuals and organisations. F1F9 instructors with extensive real-world experience run live online courses wherever you are in the world.
Book now from GBP 795
(USD, EUR and AED also available)

Custom in-house Course

In-house
Classroom-based
Video-based
Live online
Our instructors will work with you to design a course based on an appropriate case study at the ideal level of complexity for your team.

The training can be delivered on a date convenient for you, in person or live online. Train a group at the same time with no distractions, making it an immersive and hands-on experience.
Get a quote or speak to an instructor

Get in Touch

Reach out to our team of financial modelling consultants who are ready to assist you, whether you’re in the research phase or have specific needs in mind, we’re here to provide the guidance you need.

Meet our instructors

Andrew Berkley - F1F9 instructor
Andrew has delivered financial modelling courses to numerous institutions including European Bank of Reconstruction and Development, Deloitte, KPMG, Grant Thornton and Si...

Andrew Berkley

Andrew has delivered financial modelling courses to numerous institutions including European Bank of Reconstruction and Development, Deloitte, KPMG, Grant Thornton and Siemens. He is an experienced model builder and reviewer with sector experience in telecommunications and transport. He has also worked with smaller businesses in preparing financial forecasts for early stage equity funding proposals. Andrew is a Chartered Accountant and has been delivering corporate training courses since 2004.
Andrew Berkley
John Dimberline - F1F9 instructor
John Dimberline is an expert financial modeller with 18+ years of experience advising clients on a wide range of modelling assignments. John has recently led our work ...

John Dimberline

John Dimberline is an expert financial modeller with 18+ years of experience advising clients on a wide range of modelling assignments. John has recently led our work with the Utility Regulator of Northern Ireland in the development of their RP6 price determination model, and our work with Ofwat on their PR19 suite of models. In his previous role as the head of Grant Thornton’s national financial modelling team, John has managed modelling assignments covering corporate finance advisory, regulators, oil & gas, highways, housing and regeneration, emergency services, education, renewables and waste. This experience has been gained on model build, operation, review and model audit assignments.
John Dimberline
John Richter - F1F9 instructor
John Richter has 20+ years of experience with spreadsheet-based project evaluation and market forecast models. His experience has covered all the roles of designer, build...

John Richter

John Richter has 20+ years of experience with spreadsheet-based project evaluation and market forecast models. His experience has covered all the roles of designer, builder, analyst, and training course instructor. He is the author of the FAST Standard and continues an active training schedule and hands on execution of select modelling assignments. John holds a Bachelor of Science in Mechanical and Aerospace Engineering from Princeton University, magna cum laude, and an MBA from Harvard University.
John Richter
Omar Shaker_F1F9 instructor
Omar is a highly experienced financial modeller having spent the last 15 years building FAST compliant models in the project finance advisory (debt and equity) space. He...

Omar Shaker

Omar is a highly experienced financial modeller having spent the last 15 years building FAST compliant models in the project finance advisory (debt and equity) space. He has worked on some of the largest transactions globally with aggregate value in excess of USD 20Bn. He began his career at F1F9 and went on to join the Royal Bank of Scotland (London), Standard Bank (London) and Standard Chartered Bank (Dubai). Omar has recently rejoined F1F9 as lead instructor for the MEA and APAC regions. He is fluent in Arabic both written and spoken.
Omar Shaker
Morten Siersted
Morten has unrivalled experience in developing robust and efficient spreadsheet modelling processes and building modelling teams and capacity for both F1F9 and its client...

Morten Siersted

Morten has unrivalled experience in developing robust and efficient spreadsheet modelling processes and building modelling teams and capacity for both F1F9 and its clients. He has also had a pivotal role in developing the FAST Standard, including setting up the not-for-profit FAST Standard Organisation in 2011. Morten has recently completed an MSc in International Public Policy Analysis from Bath University (within the Centre for Development Studies).
Morten Siersted
Andrew Berkley - F1F9 instructor
Andrew has delivered financial modelling courses to numerous institutions including European Bank of Reconstruction and Development, Deloitte, KPMG, Grant Thornton and Si...

Andrew Berkley

Andrew has delivered financial modelling courses to numerous institutions including European Bank of Reconstruction and Development, Deloitte, KPMG, Grant Thornton and Siemens. He is an experienced model builder and reviewer with sector experience in telecommunications and transport. He has also worked with smaller businesses in preparing financial forecasts for early stage equity funding proposals. Andrew is a Chartered Accountant and has been delivering corporate training courses since 2004.
John Dimberline - F1F9 instructor
John Dimberline is an expert financial modeller with 18+ years of experience advising clients on a wide range of modelling assignments. John has recently led our work ...

John Dimberline

John Dimberline is an expert financial modeller with 18+ years of experience advising clients on a wide range of modelling assignments. John has recently led our work with the Utility Regulator of Northern Ireland in the development of their RP6 price determination model, and our work with Ofwat on their PR19 suite of models. In his previous role as the head of Grant Thornton’s national financial modelling team, John has managed modelling assignments covering corporate finance advisory, regulators, oil & gas, highways, housing and regeneration, emergency services, education, renewables and waste. This experience has been gained on model build, operation, review and model audit assignments.
John Richter - F1F9 instructor
John Richter has 20+ years of experience with spreadsheet-based project evaluation and market forecast models. His experience has covered all the roles of designer, build...

John Richter

John Richter has 20+ years of experience with spreadsheet-based project evaluation and market forecast models. His experience has covered all the roles of designer, builder, analyst, and training course instructor. He is the author of the FAST Standard and continues an active training schedule and hands on execution of select modelling assignments. John holds a Bachelor of Science in Mechanical and Aerospace Engineering from Princeton University, magna cum laude, and an MBA from Harvard University.
Omar Shaker_F1F9 instructor
Omar is a highly experienced financial modeller having spent the last 15 years building FAST compliant models in the project finance advisory (debt and equity) space. He...

Omar Shaker

Omar is a highly experienced financial modeller having spent the last 15 years building FAST compliant models in the project finance advisory (debt and equity) space. He has worked on some of the largest transactions globally with aggregate value in excess of USD 20Bn. He began his career at F1F9 and went on to join the Royal Bank of Scotland (London), Standard Bank (London) and Standard Chartered Bank (Dubai). Omar has recently rejoined F1F9 as lead instructor for the MEA and APAC regions. He is fluent in Arabic both written and spoken.
Morten Siersted
Morten has unrivalled experience in developing robust and efficient spreadsheet modelling processes and building modelling teams and capacity for both F1F9 and its client...

Morten Siersted

Morten has unrivalled experience in developing robust and efficient spreadsheet modelling processes and building modelling teams and capacity for both F1F9 and its clients. He has also had a pivotal role in developing the FAST Standard, including setting up the not-for-profit FAST Standard Organisation in 2011. Morten has recently completed an MSc in International Public Policy Analysis from Bath University (within the Centre for Development Studies).

Case studies

Virgin Trains is a train operating company that has operated the InterCity West Coast franchise since 1997. It operates long-distance passenger services on the West Coast Main Line between London, West Midlands, North West England, North Wales and Scotland.

The company’s previous process for budgeting, reporting actuals and updating forecasts was complex and time-consuming, with the complexity leading to errors in the final output. Over 80 spreadsheets were in use across 11 departments for the budget process alone. Duplication of common inputs led to inconsistency.
Read more
Virgin Trains is a train operating company that has operated the InterCity West Coast franchise since 1997. It operates long-distance passenger services on the West Coast Main Line between London, West Midlands, North West England, North Wales and Scotland.

The company’s previous process for budgeting, reporting actuals and updating forecasts was complex and time-consuming, with the complexity leading to errors in the final output. Over 80 spreadsheets were in use across 11 departments for the budget process alone. Duplication of common inputs led to inconsistency.
F1F9 created a new process for updating, analysing and communicating large financial datasets in 8 Excel financial models which take inputs from core non-Excel management information systems. This dramatically increased budgeting and forecasting efficiency as well as reducing the risk of errors. The reporting process is now simple and more accurate with a rapid turnaround. We worked in close collaboration with our Virgin Trains contacts and completed the work in 2 months. The new process has been fully adopted within Virgin Trains and F1F9 are providing ongoing support.
Power NI is the largest electricity company in Northern Ireland. Their parent is the Energia Group, a leading integrated Irish energy business with substantial businesses in both the Republic of Ireland and Northern Ireland.

In 2018, F1F9 created a best practice budgeting and reporting model for Power NI, followed by two smaller builds looking in more detail at specific elements of the business. Subsequently, Energia Group expressed a desire to improve and standardise their range of financial reporting and forecasting models.
Read more
Power NI is the largest electricity company in Northern Ireland. Their parent is the Energia Group, a leading integrated Irish energy business with substantial businesses in both the Republic of Ireland and Northern Ireland.

In 2018, F1F9 created a best practice budgeting and reporting model for Power NI, followed by two smaller builds looking in more detail at specific elements of the business. Subsequently, Energia Group expressed a desire to improve and standardise their range of financial reporting and forecasting models. In response to this we delivered a series of in-house training courses on best practice excel modelling to finance delegates from businesses across the Group. We recently supplemented this engagement with a ‘model clinic’ and remediation work to a tax model that the Energia Group identified as a priority for development.

As a result of this work, the Energia Group has realised significant efficiencies in their modelling practices. The staff we have trained are now equipped to build better structured, more robust models and have direct access to F1F9 resource wherever it adds value.
We have been working with Mubadala to standardise their approach to financial modelling (“The Mubadala Way”) since 2012. We have taught over 200 analysts from a wide variety of sectors. Our training programme uses a variety of learning approaches: self-study backed up with support from our team of modellers, informal and formal assessments, instructor-led classroom sessions and webinars. At the final stage of the programme, participants are required to present to senior members of the organisation.
Read more
We have been working with Mubadala to standardise their approach to financial modelling (“The Mubadala Way”) since 2012. We have taught over 200 analysts from a wide variety of sectors. Our training programme uses a variety of learning approaches: self-study backed up with support from our team of modellers, informal and formal assessments, instructor-led classroom sessions and webinars. At the final stage of the programme, participants are required to present to senior members of the organisation. Our initial brief was to run a programme for Mubadala’s core modellers – those professionals who work with financial models of considerable complexity on a daily basis. Based on a real-world case study, the training took participants through all the requirements for financial modelling from basic skills and drills in Excel to the design and construction of a highly complex set of financing requirements.

Since running the early programmes, we have amended the course material to give it a more general appeal (suitable for analysts for whom modelling is not core but nonetheless important). This included the development of further case studies relevant to the work being undertaken (including a hotel and a satellite). We continue to work with Mubadala’s learning and development team in improving the design of the programme.

Mubadala’s commitment to a single financial modelling standard has resulted in its analysts understanding the importance of a common approach and honing their technical skills. The course has been popular and in high demand – with participants enjoying the study material and the opportunity to present their work to senior colleagues.
Eneco is a Dutch energy company that works for all to participate in the transition to sustainable energy. It services 5.3 million customer contracts across The Netherlands, Belgium and Germany and has an ongoing commitment to promoting financial modelling skills amongst its analysts. Eneco engaged F1F9 to deliver a programme of excel modelling courses to their investment analysts. The initiative has been extended to include advanced Project Finance modelling.
Read more
Eneco is a Dutch energy company that works for all to participate in the transition to sustainable energy. It services 5.3 million customer contracts across The Netherlands, Belgium and Germany and has an ongoing commitment to promoting financial modelling skills amongst its analysts. Eneco engaged F1F9 to deliver a programme of excel modelling courses to their investment analysts. The initiative has been extended to include advanced Project Finance modelling. 70+ analysts have completed the F1F9 training. Eneco has adopted a standardised approach to modelling across the business and finance functions. Analysts are able to build high-quality models across multiple business units (wind, solar, heat and industrials).
Following a recommendation from Grant Thornton UK, Warth & Klein Grant Thornton (WKGT) with offices in Hamburg and Düsseldorf, Germany, engaged F1F9 to enhance proficiency in financial modelling in Excel, within the organisation. The participants included junior team members as well as seasoned professionals from varied service lines including Corporate Finance, M&A, Audit & Assurance, and Valuation.
Read more
Following a recommendation from Grant Thornton UK, Warth & Klein Grant Thornton (WKGT) with offices in Hamburg and Düsseldorf, Germany, engaged F1F9 to enhance proficiency in financial modelling in Excel, within the organisation. The participants included junior team members as well as seasoned professionals from varied service lines including Corporate Finance, M&A, Audit & Assurance, and Valuation. Since 2015 and supported by WKGT’s in-house FAST modelling champions, we have delivered several intensive in-house financial modelling courses and provided ongoing post-course learning in the form of online tutorials and support from our modelling experts. The training has been delivered in German using F1F9 staff based in Germany and has been held annually since 2015.

The course participants gained a deeper understanding of efficient modelling and a general improvement in their Excel skills. This knowledge facilitates decision making by providing easily-understood results in reasonable timeframes. The modular structure of FAST has also reduced the time it takes to review models, particularly larger or more complex ones.
In 2016, F1F9 won a tender to work with Ofwat, the body responsible for economic regulation of the privatised water and sewerage industry in England and Wales, and we continued to support them through to 2018. We worked closely with the regulator to rebuild the 2019 price review model (PR19) that Ofwat and the regulated water companies would use in the price review process.
Read more
In 2016, F1F9 won a tender to work with Ofwat, the body responsible for economic regulation of the privatised water and sewerage industry in England and Wales, and we continued to support them through to 2018. We worked closely with the regulator to rebuild the 2019 price review model (PR19) that Ofwat and the regulated water companies would use in the price review process. A large number of complex and interrelated elements need to be incorporated into this type of model, with further layers of complexity introduced from functionality for sensitivities, adjustments and overlays. Transparent calculations and consistency of excel model structure was paramount for this tool, which led Ofwat to specify a model built using the FAST standard. F1F9 worked very closely with the Ofwat Analytics team to develop a model that they were confident would facilitate a smooth and efficient price review.

Our client described their experience of working with us:
“F1F9 has been a flexible, responsive partner for the PR19 model build. With a large team of skilled financial modellers they have always been able to meet our financial modelling requirements, even when deadlines have been very short… I have shared beta versions of the model with companies and feedback from them has been positive: companies have found the FAST-compliant model much more transparent and easier to use. Feedback on the model from internal Ofwat stakeholders has also been very positive”.
Masdar is a global leader in renewable energy and sustainable urban development and has more than a decade of experience working in partnership with business and government as a renewable energy developer and investor. Masdar chose F1F9 as its modelling partner to provide support in the development and monitoring of investments in renewable wind and solar energy projects. We have been adding value to their modelling work since 2012.
Read more
Masdar is a global leader in renewable energy and sustainable urban development and has more than a decade of experience working in partnership with business and government as a renewable energy developer and investor. Masdar chose F1F9 as its modelling partner to provide support in the development and monitoring of investments in renewable wind and solar energy projects. We have been adding value to their modelling work since 2012. Masdar wanted a single point of contact to coordinate the delivery of consistent modelling solutions for several projects under development as well as for a portfolio of operational projects. F1F9 applied the FAST standard and highly-refined model structures to build models that gave both clarity to calculations and maximised the commonality between models. This was supported by bespoke classroom training and reinforced with online resources. We worked closely with the Masdar team to develop effective dashboards focussed on user efficiency and printable reports to communicate results to decision makers.

F1F9’s approach meant that our client’s teams could achieve their desired improvement in transparency and usability across the model estate. The models were used by Masdar to support numerous operational and business development projects, with the experience gained on each project improving productivity on the next.
F1F9 engaged with Energy Saving Trust (EST), a world leading centre for advice and research working with businesses, governments, consumers and communities to promote domestic energy efficiency. Ricardo Energy & Environment, developed a financial model for EST to help community groups understand the potential profitability of community renewable investments. The model has been published as part of Scottish Government’s Community and Renewable Energy Scheme (CARES). We reviewed the template model to give EST an appropriate level of confidence that the tool could be reliably used by the community groups.
Read more
F1F9 engaged with Energy Saving Trust (EST), a world leading centre for advice and research working with businesses, governments, consumers and communities to promote domestic energy efficiency. Ricardo Energy & Environment, developed a financial model for EST to help community groups understand the potential profitability of community renewable investments. The model has been published as part of Scottish Government’s Community and Renewable Energy Scheme (CARES). We reviewed the template model to give EST an appropriate level of confidence that the tool could be reliably used by the community groups. F1F9 agreed a scope of work that maximised the impact of review time. We undertook a focussed review of the construction phase calculations, including costs and financing, and of the operations phase, reviewing power prices, revenues, costs, financing and tax. Because we were reviewing a template model to be used by multiple user groups, we checked workings against the model’s extensive user notes and stress tested the model by changing assumptions, dropdown inputs and scenarios. We also reviewed the model for ease of use and understandability alongside a technical and best practice review.

F1F9 worked alongside Ricardo to deliver a review report which clearly described and prioritised findings within the agreed time frame. With the comprehensive review report and regular dialogue, Ricardo could easily act upon our review findings making the template model more reliable to use. The model has now been in use for 2 years, and F1F9 have provided further support to give confidence in the model as it continues to evolve.
F1F9 worked with the Amber Infrastructure team, a leading international infrastructure specialist focussed on development, financing and investment in public infrastructure. Amber was assessing an investment for the National Digital Infrastructure Fund (NDIF) for the acquisition of a substantial minority shareholding and provision of capital facilities in NextGenAccess (NGA), a wholesale broadband company.
Read more
F1F9 worked with the Amber Infrastructure team, a leading international infrastructure specialist focussed on development, financing and investment in public infrastructure. Amber was assessing an investment for the National Digital Infrastructure Fund (NDIF) for the acquisition of a substantial minority shareholding and provision of capital facilities in NextGenAccess (NGA), a wholesale broadband company. We reviewed the forecasting and valuation model developed by NGA to give Amber an appropriate level of confidence in the forecasts before entering into the transaction. F1F9 agreed a scope of work with our client that maximised the impact of our review time — including technical review, logical review, sensitivity testing and model specific elements. The model included a large number of repeated structures for several classifications of upfront and recurring revenues and costs, so a bespoke element of our review focussed on confirming the consistency of these calculations and that all of the calculated values flowed correctly to the financial statements.

F1F9 worked alongside Amber to deliver a comprehensive review report within the project timetable. Our findings were clearly described and prioritised, enabling our client quickly to identify points that needed to be addressed before completion. Regular dialogue throughout the process meant our client remained in control at all times, with complete clarity of the approach to the review and its findings and resolutions.
F1F9 worked closely with the Finance Director at Rocket Marketing Group, a business that creates, develops and manages a variety of added-value reward and customer loyalty programmes. Our client needed to create a forecasting model to support the planning of a medium-term business strategy and, by the end of the process, have the capability to build models of similar complexity without help.
Read more
F1F9 worked closely with the Finance Director at Rocket Marketing Group, a business that creates, develops and manages a variety of added-value reward and customer loyalty programmes. Our client needed to create a forecasting model to support the planning of a medium-term business strategy and, by the end of the process, have the capability to build models of similar complexity without help. We planned a combination of online modelling resources, on-the-job coaching, and joint design and build — all to fit within the available budget. Online excel financial modelling resources could be utilised when time allowed and when content was relevant to the build. The model build itself was facilitated by regular video conferences for planning, discussion of approach and targeted training on specific aspects of the model. We took responsibility for parts of the build where Victoria needed to focus on her role as Finance Director.

Our flexible response to the needs of Victoria and Rocket enabled them to gain the key business insights they needed, and to be equipped for whatever analysis the business will demand in the future.

Our clients

Asset Alliance Group logo
Energia logo
Drax logo
I use my new found skills on a daily basis and can’t speak highly enough of the course and what it has given myself and my colleague. It has changed how we do all of our modelling in the company and has received really positive feedback from everyone that has used the model or reviewed the model.
Sally Brierley, Financial Modeller, FCC Environment
We were stunned at the difference that a standardised approach made. Our new Excel models can provide information that just isn’t accessible through an ERP.
Philip Whittingham COO (and former FD), Virgin Trains
The course was great. I learned so much and really enjoyed it. I’m looking forward to using it in my own work. I would be very happy to recommend the course.
Eric Eastlund, Head of Analytics, SCIO Capital
From start to finish the team were very professional and demonstrated considerable experience in what they were doing. The end result is an exceptionally powerful tool, which is straightforward to use, and now forms the backbone to our forecasting process. I would have no hesitation in recommending F1F9.
Douglas McArthur, CA Group FD, Asset Alliance
[The instructor] was enthusiastic about the material and the course itself which created good engagement in class. I particularly liked the fact that we were consistently taking part in the course, rather than being "taught" we were facilitated.
Andrew Dias, Finance Business Partner, Stansted Airport
The Enterprise model is great value for money. We compared it to the other standard reporting systems available such as Sage and Oracle but the F1F9 solution was much cheaper and also gave us the flexibility to change the way we report our business as it grows and develops. It has halved the time our month end reporting process takes. We started out wanting a model for budgeting purposes only but when we saw what the model could do we decided to use it for actuals reporting as well as our rolling forecasts.
Charles Carolan, Senior Financial Analyst, Skrill
[The instructor] was absolutely excellent. Everything was extremely clear, the pace of the class was spot on. I thought I would come away being slightly better at reading models but actually now I would feel completely confident starting my own.
Emma Paterson,  SSE/ Beatrice Offshore Windfarm Limited 
The team at F1F9 were responsive, hardworking and helped us upgrade our model to be fit for purpose post acquisition. F1F9 took the time to understand our needs early in the process, met deadlines and were professional in their approach.
Investment Manager, UK Private Equity House
Thanks for the excellent academy which has so boosted my own modest modeling skills. F1F9's strong customer service culture is a big help.
Geoffrey Finch, Resident Adviser for Infrastructure Finance for the US Treasury Office of Technical Assistance - Government of Paraguay, Ministry of Finance
I particularly liked the setup of the online training, and the portions provided in each section. The ability to go back and review and exercise with the models after each training and even after a few training provided an excellent opportunity to really 'learn' the skills. The setup allowed for my own pace of learning and the time I was able to dedicate besides work to complete the training. I highly recommended the training to colleagues.
Hartmut Weissmann
Very useful tips and tricks, certainly helped me a lot in understanding and 'simplifying' the enormous models. Thank you very much!
Julie de Bock, Senior Advisory / Corporate Finance, BDO

Learn Financial Modelling with F1F9 in the UK

Level up your modeling skills with expert and certified training and learn financial modelling for your business or as part of an organisation’s requirements. Our intensive courses, led by experienced F1F9 instructors, will enhance your modeling capability. Choose from major cities including London and Dubai for in-person training, and live-online courses are also available so that you can learn financial modelling wherever you’re based in the world.

If you prefer a more customised approach, we offer tailored in-house training for your business. To learn financial modelling, start today and get in touch with your experts of choice – F1F9.