Rickard Wärnelid will be presenting a seminar on best practice guidelines in Excel for business analytics and decision analysis on Monday 19th September for the Institute of Chartered Accountants in Sydney. This practical and interactive training session will outline how organisations benefit from improved decision analysis in Excel.
Key techniques for improving business decision-making and analysis:
- Rapid evaluation of business scenarios using a Scenario Manager
- Key driver analysis – a powerful approach to identifying what really drives your business
- Working with historical data to build forecasting models
- Forecasting techniques and hands on examples in Excel
- Best-practice guidelines for structured financial modelling
Rickard will demonstrate these techniques using SMART financial modelling, a best practice modelling methodology tailored for professionals with an accounting or finance background.
SMART financial modelling
The SMART financial modelling methodology emphasises transparency, flexibility and presentation and introduces rules that underpin how Excel can be used to achieve this. When followed, these rules ensure you develop robust and flexible financial models that achieve not just their design objectives but the objectives of all users.
- Transparency: A transparent financial model is clear, simple and easy to understand. It enables updates and reviews to be made efficiently and cost effectively
- Flexibility: A flexible model can accommodate significant updates or different scenarios quickly and reliably without having to undertake significant structural changes.
- Presentation: The presentation and style of a model assists users to operate it effectively and top interpret and communicate the results
This modelling methodology is also taught in all of our financial modelling training courses. Find out more about our training programme or view our full global training schedule.
Post new comment