Sign Out
Logged In:
 
 
 
 
 
Tab Image

Essential Financial Modelling in Excel

 
         
  Ref. 309  
  Stephen Coe
  17 - 19 June 2014, Birmingham
  £1,560 + VAT Members
  £1,710 + VAT Non-members
  Hands-on course
         

 

   
   Foundation
   Descriptive NA
   Predictive 100%
   Prescriptive NA
 

What delegates will learn from the course

Gain hands-on experience of building more advanced financial models; combining techniques and features to build more usable models; importance of modular design and design methodology; how to solve business problems through spreadsheet modelling; how to add risk analysis and optimisation to existing models.

  • Introducing risk techniques and a single point project model; limitations data tables and multiple answers; scenarios
  • Further risk techniques: standard deviation; coefficient of variation; project deviation; certainty equivalents; options approach and probabilities
  • Simulation and decision tree models:  Setting up the model
  • Optimisation and targeting: adding goal seek and solver to the risk model

Course provider: Coe & Co

If you are interested in further information, have any requirements (e.g. an alternative course date), or have difficulty booking a course online then please contact Jennie Phelps. It is recommended that courses are booked online. If this is not possible, then please print off, fill and fax or post the Training Course Booking Form.

 
Jennie Phelps   Address:  The OR Society, Seymour House, 12 Edward Street, Birmingham, B1 2RX, UK
  Tel: +44 (0)121 233 9300
  Fax: +44 (0)121 233 0321
  Email: jennie.phelps@theorsociety.com