We provide a wider range of training options. Tailored and customized, we can deliver your organization’s training needs anytime, anywhere.
Why Choose this Training Course?
This Financial Modelling in the Oil & Gas Industry training course is designed to enhance participants understanding of advanced use of Excel. The global competitive environment affecting firms across all sectors including Oil & Gas companies. The ability of using Excel to its fullest is the minimum requirement to remain competitive in the current environment. This training course is designed to provide in-depth knowledge of using Excel in financial modelling. Upon completion the delegates will have the skills to use Excel efficiently, understanding how to deal with several important issues related to financial modelling, performance measurements and setting targets using sophisticated techniques. The delegates will have the knowledge to explain and propose various methods relevant in enhancing company performance.
In addition, working in the upstream or downstream and the career progression is being restricted by outdated knowledge of modelling techniques, measuring performance, and limitations. This training targets areas of weakness, so that participants will be able to build-up their confidence in financial modelling and moving their career forward.
This PetroKnowledge Financial Modelling in the Oil & Gas Industry training course will highlight:
Applications of Excel from the basics to the most advanced use of Excel
A real-world approach to the discipline
Numerous examples based around the oil and gas industry
A dual approach that develops not only modelling skills but also financial management skills
In-depth analysis of the performance using statistical techniques
What are the Goals?
By the end of this Financial Modelling in the Oil & Gas Industry training course, the participants will be able to:
Improve the quality of the quantitative analysis of corporate presentations
Apply financial modelling in the oil and gas industry
Effectively assess the appropriate discount rate
Use various models of investment appraisal techniques
Use business statistics to enhance operations and target setting for the organization
Who is this Training Course for?
This Financial Modelling in the Oil & Gas Industry training course is a suitable wide range of professionals but will significantly benefit:
Decision Makers and Performance Monitoring Specialists
Budgeting and Financial Modelling Specialists
Accountant and Analysts
Financial Analysis Specialists
Junior Managers in Data Analyst
How will this Training Course be Presented?
Each of the sessions will involve formal lectures, demonstration of modelling techniques, and the opportunity for practical application. Practical examples, and the use of mini cases will assist participants to understand the practical applications of the techniques used and prepare them to use these skills in their workplace.
The organisation will benefit the following upon participating this PetroKnowledge Financial Modelling in the Oil & Gas Industry training course is profound:
Providing opportunities to develop high-level financial management techniques
Appropriate application of the financial modelling to the Oil and Gas industry
Updating their quantitative techniques to enable them to make a better-informed decision
Transforming Excel skills to advanced knowledge of Excel for financial modelling
Enhancing the ability to apply business statistics
Effective data analysis to improve day-to-day operation activities
The impact of this training course to the participants are manifold and includes:
Advanced ability in financial modelling using Excel
Gain larger skills set when contributing to corporate decisions
Ability to question important decisions formed using financial modelling
Ability to use statistics in the operation and performance measurements
Setting consistent targets using statistical analysis
A clear understanding of performance measurements
Day One: Introduction to the Excel Environment with Oil and Gas
A Quick-start Tutorial for Excel
Describing Data Sets Using Statistics
Representing Data sets Graphically
Understanding the Concept of Normal Distribution and practical application
Trend Analysis Using Excel
Time Series Analysis
Day Two: Statistical Analysis (Applied to the Oil and Gas Industry) Using Excel
Use of Excel Functions for Statistical Analysis
Descriptive Statistics and their applications:
Use of Scatter Diagrams, Frequency and Histogram Distribution
Regression Techniques to Calculate the Cost of Equity Financing
Analysis of Equity Returns of Oil and Gas Industry and Companies
Day Three: Oil Product Spreads
Examining the Relationship between Energy Products
Differences between Data Sets and their importance.
Application of Analysis of Variance (ANOVA)
Day Four: Investment Appraisal Using Excel
Investment Appraisal using NPV, IRR, and Payback as Applied to the Oil and Gas Industry
Use of Excel Functions for Investment Appraisal: IRR, PV and NPV
Modified Internal Rate of Return (MIRR)
Use of Scenario Analysis and Stress Testing
Predicting Financial Distress
Day Five: Financial Analysis in the Up and Down Stream Oil and Gas Industry
Introduction to Financial Statements
Ratio Analysis Applied to the Oil and Gas Industry
Ratios as a System – Pyramids of Ratios
Cash Flow Forecasts Using Excel
On successful completion of this training course, a PetroKnowledge Certificate will be
awarded to the delegates
In Association With
Our collaboration with GLOMACS aims to provide the best training services and benefits for our valued clients