Applied Reservoir Engineering Using MS Excel
Boost your team's skills and your budget! Enjoy group discounts for collaborative learning. Send an inquiry to info@peassociations.com.
Applied Reservoir Engineering Using MS Excel
This self-paced course provides a hands-on approach to reservoir engineering, teaching you how to perform critical calculations and build robust analysis tools using MS Excel. It covers essential topics such as drive mechanisms, flow regimes, volumetric estimation, and aquifer analysis through practical spreadsheet exercises.
Description
Bridging the gap between theoretical reservoir engineering and practical application often requires the ability to build your own analysis tools. This e-learning program guides professionals through the creation of Excel-based workflows for solving complex reservoir problems. Participants will explore critical methodologies such as gas and oil well testing, material balance equations, and fractional flow curves. The curriculum emphasizes the step-by-step construction of spreadsheets to calculate PVT properties, estimate reserves, and model aquifer influx, empowering engineers to perform independent analysis without relying on "black box" commercial tools. Excel spreadsheets and templates will be provided to facilitate the learning process.
A crucial element in raising productivity is scientifically understanding the gaps and uncertainties in reservoir performance. Lack of expertise in fundamental calculations can lead to inconsistent results. This course is designed to deepen your understanding of important reservoir engineering topics by building them from scratch in Excel. By mastering these core calculations, learners will gain the confidence to validate data, perform quick look evaluations, and understand the physics driving their assets.
Participants will learn to perform volumetric calculations and estimate hydrocarbon in place (OOIP/OGIP) using Excel-based models. The course enables learners to calculate fluid properties (Z-factor, compressibility, viscosity) using correlations, analyze drive mechanisms (water, gas cap, gravity, depletion), and perform comparative analysis. Additionally, engineers will acquire the skills to interpret well test data (Horner plot, buildup tests), calculate skin and permeability, and model water influx using Hurst-van Everdingen and Fetkovich methods.
This is a self-paced e-learning program designed to provide a deep understanding of applied reservoir engineering through calculation-based case studies. The methodology focuses on the manual construction of Excel spreadsheets to solve engineering problems, providing downloadable templates and exercises that allow professionals to build their own toolkit of analytical solutions.
Organizations will benefit from engineering teams that possess a transparent, first-principles understanding of reservoir calculations. By equipping staff with the ability to build and verify their own Excel models, companies can reduce reliance on external tools for routine tasks, improve the speed of quick-look evaluations, and ensure that decision-making is based on a solid understanding of the underlying physics rather than just model outputs.
You will gain advanced technical competence in practical reservoir engineering, mastering the ability to translate textbook equations into working analysis tools. This training enhances your analytical skills in key areas such as material balance, well testing, and fractional flow analysis, empowering you to independently verify results and solve complex problems using universally available MS Excel tools.
Reservoir Engineers
Petroleum Engineers
Production Engineers
Engineering Students and Graduates
Module 1: Reservoir Fundamentals
Module 2: Fluid Properties (PVT) Modeling
Module 3: Reserve Estimation & Volumetrics
Module 4: Flow Regimes & Well Testing
Module 5: Gas Well Performance
Module 6: Water Influx & Fractional Flow
On successful completion of this training course, PEA Certificate will be awarded to the delegates.
This course has been meticulously developed by a seasoned PEA expert renowned in the oil and gas industry. With extensive hands-on experience and a proven track record in delivering innovative solutions, our trainer brings a wealth of technical expertise, deep industry insight, and a commitment to excellence. Learners can trust that they are gaining knowledge from a leading authority whose dedication to professional development ensures you receive only the highest-quality training to elevate your skills and career prospects.
Frequently Asked Questions
All course bookings made through PEA are strictly non-refundable. By registering for a course, you acknowledge and accept that all fees are payable in full and are not subject to refund under any circumstances, including changes in personal or professional commitments or partial attendance.
PEA reserves the right to make reasonable adjustments to course content, trainers, or schedules where necessary, without entitling delegates to a refund. Comprehensive details of each course — including objectives, target audience, and content — are clearly outlined before enrolment, and it is the responsibility of the delegate to ensure the course's suitability prior to booking.
For any inquiries related to cancellations or bookings, please contact our support team, who will be happy to assist you.