An Interactive 5-Day Training Course
Advanced Drilling Engineering Using MS Excel
Advanced Excel for Drilling Engineers
Secure your spot now!
Duration
5 Days
Price
$ 2,500
Starting From
14 Feb 2027
Advanced Drilling Engineering Using MS Excel
Have Questions ?
Advanced Drilling Engineering Using MS Excel - DC-AD-EXCEL-PEA27
| Code | Date | Time | Duration | Location | Currency | Early Bird Fee Per Person |
|---|---|---|---|---|---|---|
| DC-AD-EXCEL-PEA27 | 14 - 18 Feb 2027 | 10 AM CST | 4 Hours / Day |
Online |
USD |
2500 |
Need this for a group? We deliver the same course in-house — face-to-face at your location or online — tailored to your assets and team level. Contact info@peassociations.com
Boost your team's skills and your budget! Enjoy group discounts for collaborative learning. Send an inquiry to info@peassociations.com.
Advanced Drilling Engineering Using MS Excel
This course builds advanced drilling models in Microsoft Excel. Participants build iterative hydraulics, torque and drag, tubular design, temperature profiles, surge and swab, well control simulation, Monte Carlo cost models, large data analysis and dashboards, using live formulas, iterative calculation and Excel's analysis tools with no macros, add-ins or coding.
Description
Once the basic drilling calculations are built, the harder ones follow: calculations that iterate, models that step along the wellbore, probabilistic cost estimates and analysis across hundreds of wells. All of them can be built in Excel with live formulas, and building them gives engineers models they understand and can modify.
This course covers that level. It builds iterative solutions using Excel's iterative calculation and Goal Seek, then develops stepwise models along the wellbore: torque and drag by element, hydraulics with temperature and pressure effects, temperature profiles and surge and swab. It builds full tubular design workbooks with multiple load cases and triaxial checks, well control simulation including circulating a kick, Monte Carlo cost and duration models using Excel's own functions, and large data analysis using PivotTables, Power Query and dynamic array formulas. The course closes with dashboards and reporting. Everything is built with live formulas, iterative calculation and Excel's built-in tools, with no macros, no add-ins and no coding.
Stepwise models are the key technique. Torque and drag, hydraulics with varying temperature, temperature profiles and surge and swab are all built by dividing the well into elements along the depth, calculating each from the one before and summing. Once that pattern is understood, a wide range of drilling models becomes buildable.
Iteration is handled with Excel's own tools. Several drilling calculations are implicit, where the answer appears on both sides of the equation, and Excel's iterative calculation setting or Goal Seek solves them directly without any code.
Monte Carlo analysis needs nothing more than Excel's random and statistical functions. Well duration and cost are uncertain, and a distribution of outcomes is a more useful answer than a single number. Building it with live formulas keeps the model transparent and auditable.
By the end of this training, participants will be able to:
- Build iterative calculations using Excel's iterative solver and Goal Seek.
- Build stepwise models that calculate along the wellbore element by element.
- Build torque and drag models with hook load and torque profiles.
- Build hydraulics models including temperature and pressure effects.
- Build wellbore temperature profile models.
- Build surge and swab pressure calculations.
- Build tubular design workbooks with multiple load cases and triaxial checks.
- Build well control simulation including circulating out a kick.
- Build Monte Carlo cost and duration models with Excel functions.
- Analyse large well data sets with PivotTables, Power Query and dynamic arrays, and build dashboards.
The course is instructor-led and entirely hands-on in Microsoft Excel. Participants build each model themselves during the sessions, testing against known results and published examples. All models use live formulas, iterative calculation and Excel's built-in analysis tools, with no macros, add-ins or coding. Participants keep everything they build. Familiarity with basic drilling calculations in Excel is assumed.
Organisations sending participants to this training will:
- Build drilling models in-house without specialist software licences.
- Give engineers models they understand and can modify.
- Apply probabilistic methods to well cost and duration estimates.
- Analyse drilling data across campaigns efficiently.
- Improve transparency and auditability of engineering models.
Participants will:
- Be able to build advanced, iterative drilling models in Excel.
- Be able to build stepwise wellbore models.
- Be able to build Monte Carlo cost and duration models.
- Be able to analyse large data sets with Excel's modern tools.
- Take away a set of advanced working models.
- Drilling engineers
- Well planners and design engineers
- Drilling performance engineers
- Cost and planning engineers
- Service company technical staff
- Engineers building in-house drilling models
Module 1: Advanced Workbook Techniques
- Iterative calculation settings
- Goal Seek and solving implicit equations
- Dynamic array formulas
- Structured tables and references
- Model architecture for large workbooks
Module 2: Stepwise Wellbore Models
- Dividing the well into elements
- Calculating element by element
- Accumulating results along the string
- Handling deviated and horizontal sections
- Verification against known results
Module 3: Torque and Drag
- Soft string model implementation
- Friction factor handling
- Hook load profiles for tripping and drilling
- Torque profiles
- Calibration against measured data
Module 4: Advanced Hydraulics
- Pressure loss with temperature and pressure effects
- Rheology models and parameter fitting
- Equivalent circulating density profiles
- Hole cleaning along the wellbore
- Sensitivity analysis
Module 5: Temperature Profiles
- Circulating temperature modelling
- Static temperature build-up
- Inputs and assumptions
- Application to fluid and tubular design
- Profile charting
Module 6: Surge and Swab
- Surge and swab pressure calculation
- Tripping speed limits
- Closed and open ended pipe
- Comparison with the pressure window
- Operating envelope sheets
Module 7: Tubular Design Workbooks
- Multiple load case handling
- Triaxial stress calculation
- Design envelope plotting
- Connection limits
- Design factor summary tables
Module 8: Well Control Simulation
- Kick volume and pressure calculation
- Circulating out a kick step by step
- Pressure schedules
- Choke pressure prediction
- Comparison with field data
Module 9: Monte Carlo, Data Analysis and Dashboards
- Random sampling with Excel functions
- Duration and cost distributions
- P10, P50 and P90 outputs
- PivotTables and Power Query for well data
- Dashboard construction and reporting
Upon successful completion of this training course, delegates will be awarded an official Certificate of Completion issued by the Petroleum Engineers Association (PEA), an ISO 9001:2015 certified training organization. The certificate carries 10 Credits and formally records the total learning hours completed.
Each certificate is signed by the Course Facilitator and the CEO of the Petroleum Engineers Association, and serves as verifiable proof of professional training that delegates can present to employers and professional bodies worldwide.
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.
