Recent Course Feedback: “I loved it!  The best course I have ever attended, excellent value for money and I learnt more in the first hour in his course than I have learnt in other Excel courses together. Will recommend actively to others!” – Natasha (Consultant for Finance) 28/9/2009 “I felt the course was very good value for money and I was pleasantly surprised how relevant it was to me.  Was very willing to adapt the course to our specific needs and wishes so flexibility was very welcome.” – Paul (Project Developer) 28/9/2009

Financial Modelling Excel Masterclass - Day 3 Course Outline

DURATION	1 Day
PREREQUISITES	You need to have high end Intermediate or Advanced Excel Skills, including the topics covered in the Excel Levels 1-3 courses and Level 1 and 2 of the Excel Masterclass.
COURSE OBJECTIVES	This course is directed at experienced Excel users who are wanting to take their spreadsheets to a new level.  You will learn how to create robust and professional models utilizing Excel functionality that most Excel users do not know how to use.
COURSE DATES	Day 3: Weekday Wed, 22-Sep-10 09:30 - 16:30 £225 Weekend Sat, 25-Sep-10 10:00 - 16:30 £325 Weekday Wed, 13-Oct-10 09:30 - 16:30 £325 Weekend Sat, 23-Oct-10 10:00 - 16:30 £325 Weekday Wed, 17-Nov-10 09:30 - 16:30 £325 Evening Mon, 22-Nov-10 and Tue, 23-Nov-10 18:30 - 21:30 £325 Evening Wed, 8-Dec-10 and Thu, 9-Dec-10 18:30 - 21:30 £325 Weekday Wed, 15-Dec-10 09:30 - 16:30 £325 Evening Mon, 24-Jan-11 and Tue, 25-Jan-11 18:30 - 21:30 £325 Any One-to-One Tuition Any Date - Fully Customisable 09:30 - 16:30 £650

Day 3 uses all the techniques from Day 1 & 2 plus a few new techniques to pull together a financial model.  Day 3 will cover:

• Importing data to work with

• Reformat data to Excel friendly format

• Enhancing Your Spreadsheet with a little VBA

• Use Historical Financial Statements to calculate Free Cash Flow

  • Ratio Analysis

  • Transposing data

  • Check the Annual Compounded Rate

  • Trend Analysis

• Project Future Cash Flow

• Valuation

  • Discount Cash Flow to Present Value

  • Terminal value

  • Enterprise Value

• Sensitivity Analysis

  • Using What-If Analysis

  • Using Data Tables

• Goal Seek

  • Using Goal Seek

  • Applying Goal Seek

• Data Tables

  • Using Data Tables

  • Creating a one-variable Data Table

  • Creating a two-variable Data Table

  • Speeding up calculations with Data Tables

• Scenario Manager

  • Using Scenario Manager

  • Adding a Scenario

  • Showing a Scenario

  • Deleting a Scenario

  • Editing an existing Scenario

  • Summarising Scenarios

• Solver

  • Using Solver

  • Installing Solver

  • Applying Solver

  • changing a Constraint

  • Deleting a Constraint

• Using the Formula Auditing Toolbar

  • Tracing Precedents

  • removing Precedent Arrows

  • Tracing Dependents

  • Removing Dependent Arrows

  • Adding a new comment

  • Evaluating Formulas one step at a time

• Using the Watch Window

  • Adding a Watch to a cell

  • Adding a Watch to all the cells with Formulas

  • Displaying a cell in the Watch Window

  • Deleting a watch

  • Hiding the Watch Window

• Protecting your work

• Creating Reports

• Print Areas