Training Courses

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

Posted by Energy Institute on Wednesday, November 21, 2012


Start Date
Tuesday, March 25, 2014


End Date
Friday, March 28, 2014


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 80,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

About

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


Newsletter

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

Contact Us

Milton Keynes
United Kingdom
Phone: +44 207 993 5991
Contact Us


Stay Connected


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