For finance professionals who are looking to improve the flexibility and functionality of their financial models, this hands-on workshop will canvass important techniques for simplifying and improving the development of forecasting models in Excel using practical examples.

It demonstrates the rapid design and development of a forecasting model from scratch, given a number of key assumptions, implementing design elements to facilitate model maintenance and then a powerful technique for sensitivity analysis is introduced, incorporating a number of scenarios in the one model. Participants should be familiar with Excel and comfortable working with functions such as IF, INDEX, MATCH and XLOOKUP, basic numeric formatting and the use of data validation.