Advanced Financial Modelling for Oil & Gas

This is an interactive and hands-on 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. The course is aimed at experienced Excel practitioners who wish to consolidate their knowledge and move to a more advanced level.

A very wide range of Excel functions is covered; the course is based around hands-on exercises to show the practical application of these functions. The course also covers issues relating to best practices, the design of models, issues that arise in frequent modelling applications. An overview of the links of these topics with other areas is also provided, such as the use of macros, and of risk and simulation modelling.

Top Learning Objectives

  • Gain a thorough understanding of the key oil & gas financial modelling and project evaluation concepts
  • Master a wide set of advanced functions in Excel and their use in practice
  • Learn to construct highly flexible, robust and transparent models that follow best practice principles
  • Manipulate data sets efficiently, and their inclusion in a model in the most effective, flexible and transparent manner
  • Leverage on advanced tools in sensitivity and scenario analysis, and solve optimization
  • Develop solutions to overcome challenges faced in modelling financial situations
  • Overview of some key uses of visual basic macros (VBA) that could extend the Excel functionality shown

Who Should Attend?

This course is designed for staff involved in Project Evaluation, Feasibility Studies or Company Valuations including:

  • Business & Finance Analysts, Executives & Managers
  • Corporate Finance Executives & Managers
  • Budgeting & Forecasting Staffs & Managers
  • Finance Managers & Financial Controllers
  • Financial Advisors & Asset Managers
  • Project Investment Executives & Managers
  • Accountants
  • Investment and Credit Analysts
  • Asset Integrity
  • Project Engineering and management
  • Operations
  • Production
  • Process Engineering
  • Inspection

Event Details

22nd – 24th July 2019
Makati, Philippines