Name: Certificate in Financial Modelling Training Course
Rating: 4.7 (1076 reviews)

Scheduled Dates

02 - 06 Nov 2026

Dubai - UAE

$5,950

Why Choose this Training Course?

Financial models sit behind almost every significant decision an organisation makes: whether to sanction a new field development, extend the life of a power plant, refinance debt, or approve next year’s budget. Yet many models in daily use are fragile, undocumented and dependent on arbitrary assumptions such as a flat growth rate. This training course addresses that gap by combining sound accounting and finance theory with rigorous, transparent spreadsheet design and evidence-based statistical forecasting.

Energy organisations face additional modelling challenges: volatile commodity prices, long and capital-intensive project lives, fiscal regimes and production profiles in Oil & Gas, and long construction periods, high fixed costs, capacity factors and decommissioning obligations in nuclear and power generation. The course equips participants to capture these realities in their models while keeping them flexible, auditable and easy to present to decision makers.

This Certificate in Financial Modelling training course will highlight:

Applications of Excel from core functions to advanced analytical and automation tools
Building dynamic, integrated income statement, balance sheet and cash flow models
Business statistics, regression, correlation and ANOVA for evidence-based forecasting and target setting
Investment appraisal (NPV, IRR, MIRR, XNPV, XIRR, payback) and discount rate estimation
Sensitivity, scenario, stress testing and Monte Carlo simulation for risk-aware decisions
Sector applications for Oil & Gas (upstream and downstream) and Nuclear / Power generation
Responsible use of AI tools to build, audit, document and explain financial models

What are the Goals?

By the end of this Certificate in Financial Modelling training course, participants will be able to:

Apply financial accounting fundamentals and the IFRS Conceptual Framework to structure reliable financial models
Design models following recognised best practice: separated inputs, calculations and outputs, consistent formulas and built-in error checks
Use descriptive statistics, trend and time series analysis, regression and ANOVA to set realistic forecasts and targets
Build an integrated three-statement model with depreciation, working capital and debt schedules
Estimate an appropriate discount rate (cost of equity via regression and WACC) for corporate and energy projects
Evaluate investments using NPV, IRR, MIRR, XNPV, XIRR, payback and, for power projects, the
Levelised Cost of Electricity (LCOE)
Quantify risk through sensitivity tables, scenarios, stress tests, break-even analysis and Monte Carlo simulation
Analyse financial performance using ratio pyramids and predict financial distress
Use AI assistants productively and safely to accelerate model building, auditing and reporting

Who is this Training Course for?

This training course is suitable for a wide range of professionals but will greatly benefit:

Financial analysts, accountants and financial modelling specialists
Budgeting, planning and performance monitoring specialists
Project managers and strategic planners
Commercial, economics and business development staff in Oil & Gas companies
Finance and planning professionals in nuclear, power and utilities organisations
Junior managers and data analysts supporting corporate decision making

How will this Training Course be Presented?

This is a highly practical, laptop-based course. Each session follows a learn → demonstrate → build → challenge cycle. Approximately 60–70% of course time is spent building models in Excel.

Concise expert-led presentations — the theory and standards behind each technique
Live modelling demonstrations — step-by-step builds that participants replicate
Sector-track exercises — the same technique applied to Generic, Oil & Gas and Nuclear / Power cases
AI-assisted labs — using Copilot / AI assistants to generate, explain and audit formulas, then verifying the results manually
Mini cases and group work — small teams solve realistic decision problems and present their recommendations
Capstone project — each team builds and defends a complete decision model on Day 5

Requirements: Each participant should bring a laptop with Microsoft Excel 2019 or later (Microsoft 365 recommended for dynamic arrays, Copilot and Python in Excel). All exercise files and solution templates are provided.

Organisational Impact

By allocating personnel to this training course, the organisation will benefit through:

Improved quality and consistency of investment and budgeting decisions
Transparent, auditable models that reduce the risk of spreadsheet errors
Forecasts and targets grounded in statistical evidence rather than arbitrary assumptions
Better quantification of commodity price, cost and schedule risks in energy projects
Faster analysis and reporting through Excel automation and responsible AI adoption
Stronger financial competencies supporting strategic planning and performance monitoring

Personal Impact

As a direct result of attending this training course, participants will:

Gain advanced, practical ability in financial modelling using Excel
Build integrated models independently and with confidence
Be able to challenge and validate models prepared by others
Use statistics to measure performance and set consistent targets
Work productively with AI tools while understanding their limitations
Contribute more effectively to corporate and project decisions

Daily Agenda

Day 1: Excel and Financial Statements Basics

How the three financial statements work and link together
What a good financial model looks like: inputs, calculations, outputs
Key Excel functions every modeller needs
Cleaning and organising data quickly in Excel
Using AI (Copilot / ChatGPT) to write and explain formulas

Day 2: Simple Statistics for Better Forecasts

Average, spread and risk: describing data in Excel
Charts and trends to see what the numbers say
Forecasting sales, oil prices and power output with Excel
Correlation: how two numbers move together
Using AI to read and explain statistical results

Day 3: Building the Financial Model

Building the income statement: revenues and costs
Building the balance sheet and cash flow statement
Linking the three statements and adding error checks
Oil & Gas example: production and oil price drive revenue
Nuclear / Power example: plant output and tariff drive revenue

Day 4: Is the Project Worth It?

Time value of money: why money today is worth more
NPV, IRR and payback in Excel
Choosing the right discount rate
What-if analysis: best, base and worst cases
Finding the break-even price with Goal Seek

Day 5: Analysis, Reporting and Final Project

Key financial ratios and what they tell us
Spotting warning signs of financial trouble
A simple dashboard to present results
Group project: build and present a complete model
Best practices to keep models clear and easy to use

Certificate

Upon successful completion of this training course, delegates will be awarded an official PetroKnowledge Certificate of Completion, signed by the course facilitator. The certificate confirms successful participation and records the total learning hours completed.
Continuing Professional Education credits (CPE): In accordance with the standards of the National Registry of CPE Sponsors, one CPE credit is granted per 50 minutes of attendance.

Accreditation

Would an alternative date be more suitable?

We offer a variety of tailored training options, customized to meet your organisation's needs. Delivered anytime, anywhere, we make it easy to bring expert training directly to your team.

Related Categories

Finance & Accounting

EUROPE

MIDDLE EAST

ASIA

NORTH AMERICA

AFRICA

Certificate in Financial Modelling