The books includes extensive coverage of:
- Model design and best practices, including the optimisation of data structures and layout, maximising transparency, balancing complexity with flexibility, dealing with circularity, model audit and error-checking.
- Sensitivity and scenario analysis, simulation, and optimisation.
- Data manipulation and analysis.
- The use and choice of Excel functions and functionality, including advanced functions and those from all categories, as well as of VBA and its key areas of application within financial modelling.
See here for more