Skip to main content
Professional financial training session at Operis

Transform Your Analysts into
World-Class Financial Modelling Champions

  • Decades of Advisory Experience
  • Real-World Case Studies
  • Proven, Error-Reducing Techniques
  • Champion-Informed Curriculum

Home to World Champions & #1 FMWC Team

Enhance Personal and Team Modelling Performance

Reliably

Build models with confidence using proven best practices that reduce errors and enhance auditability.

Efficiently

Learn efficient structures and workflows that streamline model creation and improve consistency.

Faster

Accelerate modelling tasks and decision-making by mastering advanced Excel techniques and automation.

Learn from Real-World Experience & Proven Champions

Our expert-led courses draw on decades of project finance leadership and insights from Operis’s 80-strong modelling team, specialists in live project-finance deals. We equip analysts with world-class financial modelling techniques and cultivate a disciplined modeller's mindset.

Our practical approach prioritizes simplicity, error reduction, and ingenious solutions, focusing on best-practice shortcuts crucial for complex, high-stakes transactions. We avoid theory-heavy content, ensuring you learn from the best to excel and make a tangible impact.

Train with the Best: Our Championship Legacy

Our commitment to excellence is proven. Operis is proud to be home to the current Microsoft Excel World Champion and has nurtured past Financial Modelling World Champions. For several years, our team has consistently held the #1 ranking in the Financial Modelling World Cup. This championship DNA is embedded in our training, empowering you to reach the pinnacle of modelling proficiency.

To view this TikTok content, please accept functional cookies via the cookie banner.

Why Train With Operis?

Unlock your potential with our industry-leading approach to financial modelling.

Hands-On Learning

Real-world case studies from complex Project Finance deals.

Proven Techniques

Emphasis on simplicity, error reduction, and clever modelling solutions.

Industry Recognition

Graduates recognized as top performers in Project Finance.

Expert Instructors

Decades of leadership and deal experience at Operis.

Flexible Formats

Instructor-led in-person sessions and virtual options.

OAK logo

Free Access to Award-Winning Software

Free 1-year OAK licence included with every training course

What Our Clients Say

Best training courses I have ever taken.

SV - Ofgem

This is one of the best training I have ever taken. The course is a key part of our offer to modellers and those carrying out model quality assurance. It has consistently enjoyed h...

Global Companies Trust Operis

HSBC
Ofgem
Lightsource

Explore Our Expert-Led Courses

Designed to empower you with practical skills and a modeller's mindset.

Financial Modelling for Solar Energy Projects

By working through a solar project case study, you will get hands-on experience learning and implementing best practice methodologies for financing a solar plant project.
Learn more...

Course contents

  • Core structure & fast nav

    Learn efficient navigation and structuring techniques for complex models.

  • Debt sculpting & covenants

    Master the intricacies of debt sculpting and implementing key financial covenants.

  • ...and more

Key Learning Outcomes:

  • Build a fully-scoped project finance model for solar energy projects.
  • Understand and implement advanced debt structuring and sculpting.
  • ...and more

Duration:

4 Days

Cost:

£2,400

(plus VAT if applicable)

Financial Modelling for Wind Farms Projects

By working through a wind farm project case study, you will get hands-on experience learning and implementing best practice methodologies for financing a wind farm.
Learn more...

Course contents

  • Core structure & fast nav

    Learn efficient navigation and structuring techniques for complex models.

  • Debt sculpting & covenants

    Master the intricacies of debt sculpting and implementing key financial covenants.

  • ...and more

Key Learning Outcomes:

  • Build a fully-scoped project finance model for wind farms.
  • Understand and implement advanced debt structuring and sculpting.
  • ...and more

Duration:

4 Days

Cost:

£2,400

(plus VAT if applicable)

Financial Modelling for Oil & Gas Projects

By working through an Oil and/or gas project case study, you will get hands-on experience learning and implementing best practice methodologies for financing an oil and/or gas field.
Learn more...

Course contents

  • Core structure & fast nav

    Learn efficient navigation and structuring techniques for complex models.

  • Debt sculpting & covenants

    Master the intricacies of debt sculpting and implementing key financial covenants.

  • ...and more

Key Learning Outcomes:

  • Build a fully-scoped project finance model for natural resources projects.
  • Understand and implement advanced debt structuring and sculpting.
  • ...and more

Duration:

4 Days

Cost:

£2,400

(plus VAT if applicable)

Financial Modelling for European PPP Projects

Using a hands-on Excel-based approach, you will build a fully integrated model from scratch, incorporating availability payments, construction and operating costs, tax, and debt financing features common in European PPPs.
Learn more...

Course contents

  • Project timing and period structure

    Modelling construction, concession, and operational phases.

  • Availability payments and revenue indexing

    Learn CPI and BMI escalation mechanisms.

  • ...and more

Key Learning Outcomes:

  • Build a fully-scoped PPP model.
  • Understand and implement advanced debt structuring and sculpting.
  • ...and more

Duration:

4 Days

Cost:

£2,400

(plus VAT if applicable)

Financial Modelling for US P3 Projects

Using a hands-on Excel-based approach, you will build a fully integrated model from scratch, incorporating availability payments, construction and operating costs, tax, and debt financing features common in US PPPs.
Learn more...

Course contents

  • Project timing and period structure

    Modelling construction, concession, and operational phases.

  • Availability payments and revenue indexing

    Learn CPI and BMI escalation mechanisms.

  • ...and more

Key Learning Outcomes:

  • Build a fully-scoped P3 model.
  • Understand and implement advanced debt structuring and sculpting.
  • ...and more

Duration:

4 Days

Cost:

£2,400

(plus VAT if applicable)

Financial Model Assessment and Review

Learn the unique and award-winning Operis' method to review financial models with maximum efficiency.
Learn more...

Course contents

  • Delta Sheets

    Utilize delta sheets for effective model comparison and change tracking.

  • Cash flow reconstructions

    Understand how to reconstruct and validate cash flow statements.

  • ...and more

Key Learning Outcomes:

  • Master Operis's unique model review methodology.
  • Efficiently identify and resolve common modelling errors.
  • ...and more

Duration:

2 Days

Cost:

£1,200

(plus VAT if applicable)

Aligning Contracts and Financial Models for Lawyers

This is an unique opportunity to take advantage of David Colver’s (founder and CEO of Operis) more than 30 years of experience in Project Finance!. In this course, David will show how contracts and financial models are directly related and what are the good practices when writing contracts or building/reviewing financial models.
Learn more...

Course contents

  • What a financial model is, and how it relates to the different project agreements

    Gain a foundational understanding of financial models in the context of project agreements.

  • How to define Debt Service Cover Ratios

    Learn the precise definitions and calculations of DSCRs.

  • ...and more

Key Learning Outcomes:

  • Understand the critical links between legal contracts and financial models.
  • Effectively interpret and analyze financial models from a lawyer's perspective.
  • ...and more

Duration:

1 Day

Cost:

£3,200

(plus VAT if applicable)

Spreadsheet Modelling for Public Sector

This course was developed in consultation with key government departments, expanding on the principles outlined in the HMT Aqua book (2015).
Learn more...

Course contents

  • Develop and use consistent range names

    Implement best practices for naming ranges to improve model clarity.

  • Use switches, masks and flags to simplify logic

    Employ advanced techniques to manage complex logic within models.

  • ...and more

Key Learning Outcomes:

  • Apply HMT Aqua Book principles to public sector financial models.
  • Develop robust and transparent models for public projects and PFI/PPP schemes.
  • ...and more

Duration:

2 Days

Cost:

£1,200

(plus VAT if applicable)

Excel VBA for Project Finance Models

Unlock the power of Excel VBA to automate routine tasks and create custom functions in your project finance models. This intensive 1-day course provides a practical foundation in VBA essentials, enabling you to enhance model efficiency and sophistication.
Learn more...

Course contents

  • VBA Essentials & Developer Environment Setup

    Get started with the VBA editor and understand fundamental concepts.

  • Core Programming Concepts: Variables & Control Structures

    Learn about variables, data types, loops, and conditional logic in VBA.

  • ...and more

Key Learning Outcomes:

  • Automate repetitive Excel tasks using VBA macros.
  • Create custom functions (UDFs) to extend Excel's capabilities.
  • ...and more

Duration:

1 Day

Cost:

£1,200

(plus VAT if applicable)

More Project Finance Courses

Our Training Calendar 2025

Plan your learning journey. Below is an overview of our course availability throughout the year.

Course TitleAugSepOctNovDec
Financial Modelling for Solar Energy Projects
London
Toronto
Remote (P1)
London
Dubai
Remote (P2)
Johannesburg
London
Remote (P1)
London
Remote (P2)
Financial Modelling for Wind Farms Projects
London
Toronto
Remote
London
Dubai
Remote
Johannesburg
London
Remote
London
Remote
Financial Modelling for Oil & Gas Projects
London
Toronto
Remote
London
Dubai
Remote
Johannesburg
London
Remote
London
Remote
Financial Modelling for European PPP Projects
Financial Modelling for US P3 Projects
Financial Model Assessment and Review
London
Aligning Contracts and Financial Models for Lawyers
London
London
Spreadsheet Modelling for Public Sector
Excel VBA for Project Finance Models

Legend:

Classroom (Full Day)
Remote (Half Day Sessions)
(L)= Limited Spots
(P1/P2)= Part 1 / Part 2 (for specific remote courses)

(This will open your browser's print dialog, where you can 'Save as PDF'.)

This calendar provides a general overview. For specific dates, locations, and to enrol, please refer to the course details by clicking on the course title or contact us.

Tailored Training Solutions for Teams

Elevate your team's financial modelling capabilities with bespoke training programs from Operis. We partner with organizations worldwide to deliver customized learning experiences that address specific objectives, integrate your proprietary materials, and foster a consistent standard of excellence. Whether in-person or virtual, our expert-led team training is designed for maximum impact and tangible results.

Who Should Attend?

Our courses are tailored for professionals seeking to master financial modelling.

Financial Analysts
Project Finance Professionals
Corporate Finance Teams
Consultants & Advisers
Mid-Career Professionals Seeking Advancement

Frequently Asked Questions

Ready to Elevate Your Financial Modelling Skills?

Join the ranks of elite financial modellers. Take the next step in your career with Operis.