Advanced Financial Modelling Course

Financial Training Associates Ltd
Course summary
Length: 2 days
Price: 1,300 GBP
Language: English
Location: London
Next available date: 20/07/2017 09:30 - London

Course Description

Advanced Financial Modelling Course

Advanced Modelling Course - 2-day Financial Modelling Training Course in London

This 2-day training course explores advanced financial modelling techniques, using Excel functions and VBA programming. Delegates will practice with data manipulation in Excel and learn how to build advanced models that will enable them to better represent and analyse financial data.

The course introduces macros and the principles of Excel VBA programming. During the 2-day programme, course participants work together to build simple macros and practice using exercises. At the end of the course, delegates will be able to solve advanced data manipulation problems using Excel VBA.

Suitability - Who should attend?

This Advanced Financial Modelling course is useful for professionals who have some experience with Excel, but want to improve their skills, or benchmark their knowledge against the advanced practices used by experienced financial modelling professionals.

Training Course Content

The Advanced Financial Modelling course is structured as follows:

Pitfalls in Excel’s investment appraisal functions

  • Pitfalls in the standard IRR function
  • Problems with the standard NPV function
  • Solving the problems with Excel’s investment appraisal functions.

Excel’s ‘What if’ functions

  • How can Excel’s ‘What if’ tools help us?
  • Can scenario manager be helpful?
  • Constructing two variable and one variable data tables
  • Warnings about data tables

Excel’s ‘Lookup’ functions: getting Excel data in the right place

  • Alternatives to the standard Vlookup function
  • Pros and cons of the alternatives: which is best?

Sorting data in Excel

  • Alternative ways of sorting data in Excel
  • The world’s quickest ever introduction to pivot tables
  • Solving the same problem using standard Excel functions
  • An introduction to Excel’s hidden Array Formulas: combining two formulas in one
  • 3D referencing in Excel: stacking sheets

Flexing a model in Excel

  • Best practice scenario analysis in Excel
  • Structuring your model to good effect: facilitating instant scenario switching
  • Making use of Excel’s form controls
  • ‘Sliding’ a model horizontally – incorporating contract extension or project delay
  • The usefulness of the ‘shortcut IF’ function – building in model timing flags
  • Building in escalation factors – how to get it right/ how to get it very wrong

Other helpful best practice tips for Excel financial modelling

  • Tips for keeping an eye on key results
  • How to tell if a model has fallen over
  • Stopping an Excel model from falling over
  • Excel’s camera and watch window
  • Navigating around an Excel model: speeding the whole thing up
  • Modelling with deliberate circular references: financial modelling on the dark side

Other helpful Excel financial modelling functions

  • Excel’s date functions
  • Rolling forward dates e.g. in a valuation model
  • Excel text functions
  • Modelling tax losses with max and min functions
  • Modelling the swing between overdraft/ revolver with max and min functions


The cost of this Advanced Financial Modelling course is £1,300 + VAT per delegate.

In-house training

Financial Training Associates can also deliver this course on an in-house basis, to meet the training requirements of your staff, offering you a flexible and cost effective training solution.

Provider: Financial Training Associates Ltd

Financial Training Associates Ltd - Experts in Finance

Financial Training Associates Ltd is a company that provides experienced finance trainers to clients who wish to run in-house financial markets training courses for small groups of their employees. Course areas encompass Excel financial modelling training, corporate finance, company valuation,...

Read more and show all courses with Provider: Financial Training Associates Ltd

Request information - obligation free

Fill out your details to find out more about Advanced Financial Modelling Course.

  Contact the provider

  Get more information

  Register your interest


Contact information for Financial Training Associates Ltd

Financial Training Associates Ltd

80-83 Long Lane
EC1A 9ET London

 Show phone number

Contact Financial Training Associates Ltd

Reviews by course attendees

Financial Controller   |   25/06/2015
Most useful training I have received in a work environment
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Request information

Find out more about this Advanced Financial Modelling Course course - simply fill out your details:

Find more courses here