A two-day course providing delegates with the skills and techniques to build flexible and robust models of financial statements in Excel.
Course Objectives:
Over the 2 days delegates will learn:
- All the Excel functions of value when building such model
- Shortcuts to speed up data analysis
- How to use Excel for sensitivity analysis and scenarios
- How to customise a model to make it easier to use and operationally more transparent
- Key features of good model design
- How to use protection and validation to maintain the integrity of the model
- Tips on auditing and navigating other peoples models
Course sizes are limited due to the practical nature of the course. Laptops are provided.