Using MS Excel for Financial Modelling and other Financial Analysis Functions
The ever-changing business environment has made it more important than ever for business professionals to accurately forecast volatile economic inputs. Being able to better analyse financial data, predict revenues and costs and assess risks to justify business decisions will give your organisation the best chance of success in today’s competitive environment.
This course is aimed at Financial Managers and other business professionals who need to develop their understanding of MS Excel to better analyse the financial drivers of their business, and understand the impact that business decisions can have on an organisation’s financial performance.
NOTE: At least 2 years’ experience working with Excel in a financial function is a pre-requisite for this course
Your comprehensive programme includes:
– Easily monitoring financial performance by implementing best practice for creating spreadsheets that track profit and cost variation, sensitivity and margin analysis.
– Understanding the most common uses of Financial Modelling, and how to develop models to enable you to make better business decisions
– Streamlining your data management, importing and analysis process by using advanced features such as DDE and OLE to link data from a variety of sources
– Learning to write Macros that will enable you to regularly perform complex multi-stepped tasks in a fraction of the time
– Introducing some of the advanced Excel Formulas that you will find you can’t live without
– Creating powerful Pivot Tables that will enable you to analyse data for trends and make more accurate forecasts
– Mitigating risk and making better business decisions by learning various approaches to “What-If” analysis that will enable you to play out a variety of financial scenarios
– Using “Regression Analysis” and “Smoothing Techniques” to create practical business forecasts and projections that will lead to better business decisions
– Creating easy-to-read reports using dashboards and charts that link back to the business analysis objectives
Do you have 8 or more delegates and want to run this course Onsite?
Click here to request a quote and get more information about our onsite training.
4-5 September 2019 (CPT), 11-12 September 2019 (DBN), 13-14 November 2019 (JHB)
Cape Town, Durban, Johannesburg
Belmont Square Conference Centre (Cape Town), Corporate Conference Centre (Dowerglen), The Riverside Hotel (Durban)
|Price||R5,975.00 excl. 15% VAT
R5,975.00 excl. 15% VAT