Financial Modelling in Excel Course/Class April 7, 2011

This course is designed for the business professional with a need to model a business situation (opportunity) or perform complex manipulations of financial data. Participants will create their own customised, user-friendly model that will transform business rules and project expectations into projected future performance. Course coverage will include the use of a structured modelling format and the strengths (and weaknesses) of various analytical techniques such as internal rate of return (IRR) and net present value (NPV). Implementation and use of the IRR and NPV functions in Excel as well as numerous other spreadsheet techniques (lookup functions, conditional sum & if formulas, autofilters, conditional formatting) will be explored in detail. Participants should be familiar with basic Excel functions including the creation of cell referenced formulas.

Official Website: http://www.cce.usyd.edu.au/course/fmex