Advanced Financial Modeling for Oil & Gas

Advanced Financial Modeling for Oil & Gas is a course that covers topics such as:

  • Flexible and Efficient Modelling using Advanced Excel Functions
    • Using Lookup functions in practice I
    • Introduction and overview of selected advanced functions, and their use in modelling and data analysis
    • Using Date functions in practice I
    • Using Text functions in practice I
    • Using Lookup functions in practice III
    • Using Lookup functions in practice II
  • Using Sensitivity Analysis for Model Design and Decision-Support
    • Principles of financial modelling, and special features of modelling for oil and gas
    • Course introduction; participant introductions and expectations
  • Review of Further Frequent Application Areas, Further Exercises and Course Consolidation
    • Recap and review of core topics in economic modellingReview of key aspects of common application areas, including core aspects as well as the potential application of advanced Excel and other modelling techniques to each
    • Further core best practices and tips in model design
    • Further hands-on examples (time-permitting and according to participants` needs)
    • Model auditing (introduction and key points)
  • Data Manipulation and Statistical Analysis using Advanced Excel Functions
    • Cleaning and manipulating data using Excel tools and functions
    • Introduction and overview of further functions, and their use in modelling and data analysis
    • Using Date functions in practice II
    • Cleaning and manipulating data using functions
    • Using Statistical functions
    • Using Information functions
    • Using Database tools and functions in practice
    • Using array functions in practice
    • Demo: selected uses of VBA macros in data manipulation (e.g. repeated queries of database with different criteria, reversing data range of any size, automatic deletion of unwanted data using, repeated extraction of specific elements, consolidation of multiple data sets into a single one)

Advanced Financial Modeling for Oil & Gas brings together:

  • Corporate Finance Executives & Managers
  • Business & Finance Analysts, Executives & Managers
  • Finance Managers & Financial Controllers
  • Budgeting & Forecasting Staffs & Managers
  • Project Investment Executives & Managers
  • Financial Advisors & Asset Managers
  • Investment and Credit Analysts
  • Accountants

Important

Please, check the official conference website for possible changes, before you make any traveling arrangements

Prices are for evaluation only.

Other Events with Similar Categories

Other Events with Similar Location or Organizer