An Intensive 5-day Training Course
Advanced Financial Modelling with Excel
Modeling Best Practices
UPCOMING SESSIONS
| Date | Venue | Fee | |
|---|---|---|---|
| 22-26 Dec 2025 | London - UK | $5,950 | RESERVE A SEAT |
| 13-17 Jul 2026 | Barcelona - Spain | $5,950 | RESERVE A SEAT |
| 21-25 Sep 2026 | London - UK | $5,950 | RESERVE A SEAT |
| 21-25 Dec 2026 | Dubai - UAE | $5,950 | RESERVE A SEAT |
| Date | Venue | Fee | |
|---|---|---|---|
| 20-24 Apr 2026 | Online | $3,950 | RESERVE A SEAT |
Training Course Overview
The Advanced Financial Modelling with Excel training course is designed to elevate your financial modeling skills to an advanced level through the analysis of real-life case studies. It also deepens your understanding of finance, empowering you to make informed decisions that reduce costs, increase profitability, and minimize risk. The course explores the latest tools and techniques for estimating sales, costs, risks, and economic variables, culminating in the development of advanced financial optimization models using Excel and international best practices.
This training course will feature:
- Practical application of advanced financial modelling skills to real life case studies in the Oil & Gas sector and your company
- Development of advanced financial knowledge and its application to business problems and decision making
- The development of Advanced Financial Models which will be of practical use to you and your organization
- Training using Excel and the latest financial analysis tools and techniques
- Supporting material in both hard and soft copy explaining key Financial and Modelling techniques and applications
Training Course Objectives
By the end of this course, participants will be able to:
- Make improved financial decisions using Excel
- Develop advanced financial models using Excel
- Apply best practice and the latest tools and techniques to analyse financial data
- Manage sales, costs and financial risk using financial models
- Prepare, use and report on advanced financial models
Designed for
This course is suitable to a wide range of professionals but will greatly benefit:
- Professionals who need to develop a greater understanding of finance
- Professionals who need to develop their advanced financial modelling skills
- Those who make decisions using financial models or are impacted by those decisions
- Those responsible for managing finance
- Those responsible for estimating sales, costs, risks and economic variables
Learning Methods
Throughout the course delegates will work on case studies and real life examples to develop their Advanced Financial Modelling and Finance skills. The course is taught by an experienced financial practitioner, who will guide you through finance and the latest tools and techniques, using a range of methods including discussions, case studies and exercises. Where appropriate, these will include real issues brought to the workshop by delegates. The course is highly participatory ensuring that delegates leave with new skills to benefit their personal and organizational development.
The Course Outline
- From Basic Modelling to Advanced Modelling
- Identifying Financial Applications for Modelling in the Oil & Gas sector
- Advanced Financial Applications of Excel
- Advanced Financial Analysis Tools in Excel
- Graphs & Charts to aid Financial Analysis
- Best Practice in Modelling with Excel
- Cost Estimation – Incremental; Inflation, PERT, Supply & Demand factors
- Forecasting using Statistical Methods in Excel – Time Series Analysis, Exponential Smoothing, Correlation & Regression Analysis
- Risk Measurement using – Probability Analysis, Correlation & Beta
- Forecasting Oil Prices using statistical models
- Measuring & Managing Investment Risk
- Forecasting Interest Rates & Exchange Rates using historical data, Interest Rate Parity Theory and Purchasing Power Parity Theory
- Developing the Financial Model using Costs and Economic Variables estimated on Day 2
- Simulating changes to Costs & Accounts Payable
- Simulating changes to Sales Volume, Oil Price & Accounts Receivables
- Financial Derivatives – Forwards, Options Futures & Swaps
- Using Derivatives to Managing Oil Price Volatility, Interest Rates & Exchange Rates
- Implementing Policies to manage change
- Evaluating growth strategies
- Models to simulate growth strategies
- The dangers of Overtrading
- Examining the impact on Working Capital
- Examining the impact on Leverage
- Mergers & Acquisitions – Modelling the impact on Share Price, Market Value, Earnings & EPS
- Case Study incorporating the skills from Day 1 – 4
- Developing an Advanced Financial Optimisation Model to meet the needs of the delegates and their organisation
- Presentation of the Model
- Testing the Model
- Improving the Model
- Decision Making & Reporting
The Certificate
- Anderson Certificate of Completion will be provided to delegates who attend and complete the course
In Association With
Learn More About
this course
How can I register for a training course?
There are several convenient ways to register for our training programs:
- Online: Explore our training calendar, choose the course that suits your needs, and click the “Register Now” button on the course details page.
- Email: Share your details, including your name, organization, email address, and selected course, by sending an email to [email protected]
- Phone: Reach out to us directly at +971 4 273 3503, and our team will guide you through the registration process.
When will I receive confirmation of my registration?
Once your registration is successfully completed, you will receive a confirmation email within 24 hours. This email will contain your registration details, invoice, and the necessary joining instructions for the course.
What does the training fee cover?
Where are your training courses held?
Our training programs are hosted at luxurious five-star hotels in prestigious destinations across the globe. Some of our popular locations include Dubai, London, Kuala Lumpur, Amsterdam, New York, Paris, Vienna, and many other iconic cities.
Can I request customized corporate training?
Yes, we offer tailored corporate training solutions to meet your organization’s specific needs. Please contact us at [email protected] or call +971 4 273 3503 for more information.
This training course is also part of the 10-day titles
RELATED COURSES
