Advanced Excel and Financial Modelling 2016

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