Reservoir engineers rely on accurate calculations and data-driven insights to optimize production and maximize hydrocarbon recovery. Excel remains one of the most widely used software tools in the industry for handling reservoir-related data. This course is designed to provide professionals with practical Excel applications tailored for reservoir engineering, helping them streamline daily tasks and improve technical analyses

This course is proposed to cover all the commonly used applications of Excel for subsurface data analysis and reservoir characterization throughout reservoir engineering aspects. Example applications of Excel includes, but not limited to, formation pressure analysis, reserve estimation, decline curve analysis, material balance analysis, convention and special core analysis, well testing analysis, immiscible displacement applications, economic evaluations and project ranking, etc. Attendees will learn how to perform the widely used applications of Excel across different reservoir engineering aspects.

This course follows a hands-on, practical approach with:

• Instructor-led demonstrations of Excel techniques.
• Step-by-step guidance on building reservoir engineering models.
• Real-world case studies and problem-solving exercises.
• Interactive discussions and Q&A sessions.
• Practical assignments for skill reinforcement.

By training employees in Excel-based reservoir engineering applications, companies can benefit from:

• Improved efficiency in reservoir data analysis and decision-making.
• Enhanced accuracy in forecasting and performance evaluations.
• Reduction in manual errors through automation of key calculations.
• Better communication of reservoir insights through dynamic reports and dashboards.
• Increased productivity in engineering workflows.

Participants will gain:

• Practical Excel skills tailored to reservoir engineering applications.
• Confidence in handling large datasets and complex calculations.
• The ability to create automated models and reports.
• A structured approach to solving reservoir engineering problems.
• Enhanced career prospects with improved technical proficiency.

• Reservoir engineers seeking to improve their Excel skills.
• Petroleum engineers involved in reservoir management.
• Data analysts working with reservoir data.
• Production engineers interested in performance monitoring.
• Geoscientists dealing with reservoir-related calculations.
• Anyone looking to streamline their reservoir engineering workflows using Excel.

Day 1

• Introduction to reservoir engineering

• Formation pressure analysis

• Fluid contacts identification

• Reserve estimation and

• Decline curve analysis

• Material balance analysis

Day 2

• Core data analysis and reservoir characterization

• Rock typing and reservoir zonation

• Fundamentals of core-log integration

• Reservoir rock typing techniques

• Preparation and selection of SCAL plugs

Day 3

• Special core analysis

• Relative permeability and capillary pressure measurements

• Normalization and averaging techniques

• Wettability measurements and evaluation techniques

• Pore throat characterization methods

• Pore throat systems combined with wettability and initial water saturation

• High pressure mercury injection capillary pressure and practical interpretation methods

• Electrical rock properties

• Resistivity index and resistivity factor measurements

Day 4

• Pressure transient analysis

• Applications of pressure & temperature data

• Pressure data integration

• Pressure profiles and material balance

• Temperature gradients and well modeling applications

• Well Testing Interpretation Tools

• Horner Plot and Semi-Log Plots

• Log-log Plot and Flow Regimes

Day 5

• Flowing material balance analysis

• Immiscible displacements applications

• Water injection project evaluation

• Buckley-Leverett Model

• Frontal advance equation method

Day 6

• Reservoir fluid analysis

• PVT data QAQC

• Compositional and flash experiments QAQC

• Material balance check for differential liberation experiments

• Water analysis & compatibility testing

Day 7

• Economic evaluation

• Project economics & cash flow modeling

• Economic indicators: NPV, IRR, PB

• Project ranking and prioritization

• Cash flow allocation

On successful completion of this training course, PEA Certificate will be awarded to the delegates