Connect with us on: LinkedIn

Level

Intermediate

Beginners need to complete pre-course work and an assessment

Duration

3 days

Overview

The course is aimed at providing a framework for the competent and versatile use of Excel in financial modelling. In addition, the course will emphasise the key skills and techniques required to model cash flows and analyse risk positions in the debt and structured finance markets.

Learning Outcomes

  • Understand and use Excel functions
  • Apply financial functions
  • Apply logical functions
  • Apply lookup and reference functions
  • Use spreadsheets to price financial instruments and model cash flow structures
  • Calculate statistical probabilities and variance
  • Optimise solutions to financial problems
  • Create user-defined functions