Home / Finance & Budgeting / Data Analytics and Financial Analysis for Oil and Gas

Course Schedule

Classroom Sessions:

Date	Venue	Fees
10 - 21 Feb 2025	London - UK	$11,900
08 - 19 Dec 2025	London - UK	$11,900

Course Description

MODULES

This training course is split into two modules:

MODULE I - Infographics & Data Analytics for Oil & Gas Reporting

MODULE II - Financial Analysis, Modelling & Forecasting

Each module is structured and can be taken as a stand-alone training course; however, delegates will maximise their benefits by taking Module 1 and 2 back-to-back as a 2-week training course.

Course Outline

Module 1: Infographics & Data Analytics for Oil & Gas Reporting

Day 1

Introduction and Descriptive Statistics

What is Data Analysis?
A reminder of elementary statistics and compensations for small sample sizes
A Quick-start Tutorial for Excel
Describing Data Sets using Statistics
Representing Data Sets Graphically
How to create Info-graphic in Excel
How Info-graphics Data Presentation compares to the Traditional Methods

Day 2

Frequency and Time Series Analysis

Frequency of Occurrence
Histograms
Pareto Analysis
How Excel Dashboard is Different from Infographics
How to combine Excel and Power Point for Creating Infographics
Time Series and Trend Analysis
Estimation Theory and Its Relevant to Oil and Gas Data

Day 3

Scenario Analysis, Confidence and Six Sigma

Modelling Scenario and their Application in Oil and Gas Companies
Interactive Spreadsheets
Confidence Intervals
Usefulness of Control Chart for Oil and Gas Companies
Error Bars
Online Tools for Creating Infographics
Practical Creation of Infographic using real Data

Day 4

Regression Analysis Equations and System Modeling

Simple Regression Analysis
Polynomial Curve Fits
Describing Data Using Equations
Prediction
The Applications of Regression to Oil and Gas Companies
Analysis Of Variance (ANOVA)
Comparing Different Types of Infographics

Day 5

The Infographics Creation and Critique

Presenting Data Using Appropriate Reporting Style
Practice Creating the Infographics and Its Presentation
Focus on the Storytelling
Overall Review of Concepts Learned and How they can be applied in practice

Module 2: Financial Analysis, Modelling & Forecasting

Day 6

The Competitive Challenge in the 21st Century

Identifying and Managing Stakeholder Needs
Business Models and How They are Disrupted
An Integrated Approach to Risk Management
The Essentials of Business Performance Management

Fundamentals of Financial Modelling

Financial Statements Basics
Fundamentals of Financial Modelling

Day 7

Mastering Financial Analysis

Building a Financial Ratio Database in Excel
Practical Modelling: The Cost-Volume-Profit Relationship
Measuring and Improving Return On Investment
Measuring and Improving Asset Management Efficiency
Measuring and Managing Capital Structure and Risk
Practical Modelling: The Effect of Gearing on Shareholders’ Earnings

Day 8

Improving Financial Forecasting

Practical Modelling: Using Excel Statistical Analysis Tools
Avoiding Common Forecasting Problems
Using Moving Averages to Analyse Time Series Data
Using Linear Regression for Sales Trend Analysis
Using Excel Solver to Minimise Forecasting Error
Using Regression and Correlation to Forecast Costs
Practical Modelling: Cash Flow Forecasting

Day 9

Financial Models to Improve Investment Decision-making

Principles of Capital Investment Decision-making
Sources and Cost of Business Finance
Practical Modelling: Using Excel Discounted Cash Flow Tools
Practical Modelling: Capital Investment Analysis
Essentials of Business Valuation
Practical Modelling: Business Valuation Based on Shareholder Value Added

Day 10

Managing Risk and Uncertainty

Identifying and Analysing Business Risk
Probability Based Approach to Decision-making
Monte Carlo Simulation
Sensitivity Analysis and “what-if” Forecasting
Identifying the Key Drivers of Financial Performance
Practical Modelling: Key Driver “what-if” Forecast

Certificates

On successful completion of this training course, GLOMACS Certificate will be awarded to the delegates
Continuing Professional Education credits (CPE) : In accordance with the standards of the National Registry of CPE Sponsor, one CPE credit is granted per 50 minutes of attendance

Providers and Associations

Endorsed Education Provider

GLOMACS is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.NASBARegistry.org

Options & Brochure

Related Categories

Finance & Budgeting

An Interactive 10-Day Training Course

Data Analytics and Financial Analysis for Oil and Gas