Training Courses

Practical workshop: Excel analysis of oil, gas and power supply chains

Posted by Energy Institute on Wednesday, November 21, 2012

Start Date
Monday, March 23, 2015

End Date
Thursday, March 26, 2015

developing and applying spreadsheet economics, risk,finance and decision evaluation models to a range ofprojects from the oil, natural gas and power supply chains.The course is built around a series of workbook modulescompatible with Excel 2010, 2007 and 2003 versions.Delegates are required to bring their own laptopcomputers loaded with a functioning version ofExcel (i.e. 2003, 2007 or 2010 version) for use duringthe course. Delegates are provided with a number ofspreadsheet workbooks to load and then evaluate withstructured exercises. Some basic knowledge of operatingExcel software is required, but detailed computermodelling expertise is not essential. The emphasis is onfit-for-purpose gas industry model applications rather thandeveloping spreadsheet skills, but both should be part ofthe learning outcomes.The course is broken down into approximately onequartertheoretical instruction and three-quarterspractical hands-on facilitated spreadsheet modelevaluation. Brief PowerPoint presentations are delivered toreview the industry topics covered and these will leadswiftly into the practical sessions. The economic analysistheory sections also aim to provide insight to the keyeconomic issues impacting the supply chains covered.Many companies make extensive use of proprietaryeconomic modelling software, often requiring macros tobe built to evaluate case-specific problems. In such cases,even though spreadsheets may not be used routinely, it isof enormous benefit for analysts and decision-makers tounderstand how such models can be built, developed andmanipulated on a spreadsheet platform. Spreadsheets inconjunction with built-in functions, add-ins and VBAmacros provide an extremely powerful platform for such analysis. The course's practical sessions will demonstratehow such features can be simply and effectively harnessedto build quite sophisticated, but highly functional,analytical models.

Popular Headlines View all

Latest Opinion View all

Join 90,000 other oil and gas professionals

Network with others, build your profile, and receive the latest oil and gas news in your inbox. It's free!

Create profile

Time for a change? All jobs Jobs near you


OilVoice, established in 2002, is your leading source of upstream news, jobs and industry information.


Each week we send our weekly industry round-up. Why not try it? You may unsubscribe at any time.

Contact OilVoice

Milton Keynes
United Kingdom
Contact Us

Stay Connected

2016 © OilVoice  .  Privacy Policy  .  Terms of Service  .  Oil Careers  .  Advertise with us