Course Description:
In business, every decision has an impact on the overall performance of the organisation. To ensure success it is vital that you are able to manipulate and analyse large amounts of data effectively and efficiently, and this requires you to be highly proficient in MS Excel. This highly practical and intensive course will demonstrate how MS Excel can be used effectively for Data Consolidation & Manipulation, Financial Modelling, Scenario Analysis as well as creating professional Reporting Dashboards containing vital business data, forecasts and projections.
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.
Click below to book this course
through our blended learning option (online). If you would like to do this
course at our training centre (classroom) instead, please click here.
Course Content:
- 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
Here are the course dates available for MS Excel Advanced - Blended Learning.
| Course Date | Start Date | End Date | Course Duration | City | Venue |
|---|---|---|---|---|---|
| 2023/04/20 | 2023/04/21 | 2 | Blended Learning - JHB | Virtual Online Training |
