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.
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.
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
Explore Our Expert-Led Courses
Designed to empower you with practical skills and a modeller’s mindset.
Financial Modelling for Renewables Energy Projects
Course contents
- Core structure & fast nav
Learn efficient navigation and structuring techniques for complex models.
- Debt sizing and sculpting
Re-profile debt service constrained by ratios or gearing.
- ...and more
Key Learning Outcomes:
- Build a fully-scoped project finance model for renewables energy projects using a solar case-study.
- Understand and implement advanced debt structuring and sculpting.
- ...and more
Duration:
4 Days
Cost:
£2,400
(plus VAT if applicable)Financial Modelling for Real Estate Acquisitions
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 flexible timeline incorporating project start, operation, and exit dates
- Model unit counts, square footage, and revenue by property type
- ...and more
Duration:
4 Days
Cost:
£2,400
(plus VAT if applicable)Financial Model Assessment and Review
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
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
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
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)Tax and Accounting for Project Finance
Course contents
- VAT & Working Capital
Master the timing of VAT flows, reclaim cycles, and modelling working capital requirements.
- Accounting Basis Assessment
Conduct risk assessments to choose between Fixed Asset and Finance Debtor accounting.
- ...and more
Key Learning Outcomes:
- Understand reclaim lags and build VAT control accounts for all project phases.
- IFRIC 12: Understand the scope of service concessions and the three accounting models.
- ...and more
Duration:
2 Days
Cost:
£1,200
(plus VAT if applicable)More Project Finance Courses
Our Training Calendar 2026
Plan your learning journey. Below is an overview of our course availability throughout the year.
| Course Title | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
|---|---|---|---|---|---|---|---|---|---|
| Financial Modelling for Renewables Energy Projects | London 13-16 Apr | Remote (P1)26-29 May | London 1-4 JunToronto 22-25 JunRemote (P2)8-11 Jun | London 20-23 JulJohannesburg 30 Jul - 04 Aug | Remote (P1)10-13 Aug | London 14-17 SepRemote (P2)01-04 Sep Remote (P1)21-24 Sep | London 26-29 OctRemote (P2)05-08 Oct | London 16-19 NovRemote (P1)23-26 Nov | London 07-10 DecRemote (P2)14-17 Dec |
| Financial Modelling for Real Estate Acquisitions | London 24-27 Aug | ||||||||
| Financial Model Assessment and Review | London 17–18 Aug | London 15–16 Oct | |||||||
| Aligning Contracts and Financial Models for Lawyers | |||||||||
| Spreadsheet Modelling for Public Sector | |||||||||
| Excel VBA for Project Finance Models | |||||||||
| Tax and Accounting for Project Finance |
Legend:
(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.
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.
