Advanced Financial Modeling for Oil & Gas 2015

Topics

• 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)

Who should Attend

• 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