2016 - Advanced Excel and Financial Modelling

This course covers fundamental skills needed to utilise Excel to best effect and then illustrates these skills in the context of developing best practice financial models. You will learn key tools of Excel which are useful for business analysis and then how to construct a reliable financial model encompassing three financial statements (balance sheet, profit and loss statement and cash flow).
This course adopts a case study approach and minimizing the level of classroom-style learning allowing participants to feel more empowered and comfortable in applying skills and techniques developed during the course in their day to day work.
By the end of the course you will be able to:
Improve your efficiency using Excel shortcuts
Use several of the support tools and techniques in spreadsheet programs
Utilise sensitivity analysis
Build a robust financial model
Analyse the results