Course Objective: This course intends to train those energy aspirants who wish to kickstart or upskill their careers in Energy analytics. In a world where Data is called the new oil, data is not useful unless it is breakdown properly and visualized in such a way that everyone understands. Data visualization has turned into a life skill for employees irrespective of their domain, hierarchy and experience.

Excel provides users with the ability to calculate, organize, and evaluate quantitative data, allowing managers and senior staff to have the information they need to make important decisions that can affect the company. By having employees trained in the advanced functions of Excel, they can better present their information all the way up to upper management. It is also a critical skill for employees hoping to climb to the top themselves.

Course Duration: 16+ Hours

Prerequisites:

• Will teach from scratch, so no perquisites as such required.
• Having knowledge of data visualization, graphs and charts will be add on advantage.

Who Can join the course:

Students and graduates from Energy industry looking to start their career as energy or Oil & Gas Analyst. interested to become an excellent analyst for Business Development and track industry growth, etc. Oil & Gas professionals who like to learn new skillsets and optimize their work efficiency.

Application in Excel Analysis for Petroleum Engineers: -

Analyse Data in Excel empowers you to understand your data through natural language queries that allow you to ask questions about your data without having to write complicated formulas. In addition, Analyse Data provides high-level visual summaries, trends, and patterns.

Important Business Benefits of the Excel Analysis for the Oil & Gas Industry: -

• It Creates Greater Efficiency and Heightens Productivity: Create equations that can allow you to provide more data on vital company functions, such as workflow, project efficiency, financial projections and budgets, and even inventory levels and usage.
• Track your growth: Create tracking systems for different departments and operations, including various workflow processes. Maintain, organize, and balance complex financial and inventory accounts.
• Quick Identification of causes for trends in the data: 
  Often in visuals, you see a large increase and then a sharp drop in values, and wonder about the cause of such fluctuations. With insights in Power BI, you can learn the cause with just a few clicks.
• Making You Better at Organizing Data: 
  Read and comprehend spreadsheets and data from other departments, vendors, and customers. Provide answers and solutions to problems affecting the business by being able to interpret data at a more advanced level.

Excel Features covered: -

• Advanced Charting 
• Data cleaning 
• Advanced Excel Functions 
• Data Analysis Tool pack 
• Excel Dashboards 
• Power Query 
• Pivot Query 
• Trend Forecasting
• Excel Macros
• Excel Tips and tricks

Course Outline:

• Production Forecast and Decline Curve Analysis 
• Monte Carlo Simulation 
• Well Performance 
• Automated Reservoir History match and Aquifer fitting 
• Petrophysical Evaluation 
• Automated Drilling Worksheets
• Pivot table Analysis of production Data