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
View on Google Maps (new window)
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.