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 ... Read more

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@ae.pwc.com URLs: Booking: http://atnd.it/54431-0 Inquiries: http://atnd.it/54431-1 Price: Standard: USD 2000 Time: 8:30 am - 4:00 pm Venue details: PwC, Dubai, United Arab Emirates