Advanced Excel 2016 - Advanced Excel and Financial Modeling training in Dubai - PwC's Academy

The Advanced Excel and Financial Modeling 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 minimising 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.
The course will help participants:
Improve their 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
Course agenda:
Basic Excel tools including shortcuts to improve your efficiency
Refresher of excel fundamentals
Customising excel
Basic structure of a model
Understanding/refresher of financial statements
Model design and consideration of inputs
Forecasting EBITDA
Making sure the model has integrity
Including checks and balances
Forecasting working capital
Forecasting capex and depreciation
Forecasting financial flows
Trouble shooting circulatory problems
Forecasting tax
The camera function
Sensitivity analysis
Charting the results
Creating impressive output
For additional details contact us at +971 4 515 7495 or trainedbypwc-AT-ae.pwc.com