Master Class: Advanced Financial Modelling for the Oil & Gas Industry

* Claim back your VAT
Find out more

Request a different date or location for this course (we regularly add courses following requests).


* Claim back your VAT
Find out more



This is an interactive and hands-on five day course aimed at developing participants’ skills in implementing a wide range of financial modelling applications that are found in the oil and gas and related sectors. Even if you do not have a lot of modelling experience, the course is designed to take you to a higher level by building a complete model in stages.

Key themes include: best international practice in designing and developing models, sensitivity and scenario analysis, tools to create highly flexible models (such as shifting cash flows in time, manipulation of data), together with implementation of risk, uncertainty, optimisation and simulation modelling.

Day 1: Foundations of financial modelling
Day 2: Key model sections
Day 3: Visual basic for applications and financial mathematics
Day 4: Risk and sensitivity
Day 5: Optimisation, reporting and simulation

Benefits of the course

After this course delegates should have achieved a number of benefits and skills:

  • Recognise situations where more advanced tools can add value in existing models
  • Become quicker, more effective and efficient in day-to-day modelling work
  • Learn a practical approach to financial modelling in the oil and gas industry
  • Leverage on advanced tools in sensitivity analysis, including modelling risk and uncertainty
  • Construct flexible, robust and transparent models that follow best practice principles
  • Manipulate data sets efficiently
  • Develop an in-depth knowledge of a wide range of advanced functions in Excel
  • Create and write VBA code
  • Develop your own solutions to challenges faced in modelling financial situations

Related Courses


We can bring this course to your company's office.

If you simply want to run this course at a location convenient to you or if you want a completely customised learning solution, we can help.

We produce learning solutions that are completely unique to your business. Our tailored learning solutions are designed specifically for your organisation’s needs.

We’ll be here to support you every step of the way. From the initial consultancy through to evaluating the success of the full learning experience. We'll ensure you get the maximum return on your training investment.

Find out more

Why us

We have a combined experience of over 60 years providing learning solutions to the world’s major organisations and are privileged to have contributed to their success. We view our clients as partners and focus on understanding the needs of each organisation we work with to tailor learning solutions to specific requirements.

We are proud of our record of customer satisfaction. Here is why you should choose us to help you achieve your goals and accelerate your career:

  • Quality – our clients consistently rate our performance ‘excellent’ or ‘outstanding’. Our average overall score awarded to us by our clients is nine out of ten.
  • Track record – we have delivered training solutions for 95% of worlds’ top 100 banks and have trained over 250,000 professionals.
  • Knowledge – our 150 strong team of industry specialist trainers are world leading financial leaders and commentators, ensuring our knowledge base is second to none.
  • Reliability – if we promise it, we deliver it. We have delivered over 20,000 events both in person and online, using simultaneous translation to delegates from over 180 countries.
  • Recognition – we are accredited by the British Accreditation Council and the CPD Certification Service. In an independent review by Feefo we scored 96% on service and 95% on product