This session demonstrates the use of dynamic array formulas in the creation of forecasts.  It covers when you can and cannot use dynamic arrays in common tasks, and how to process calculations row-by-row and column-by-column in blocks of calculations.  It covers functions that will and those that won't work in dynamic array formulas, and the alternative calculations that let you process values effectively.  It discusses when and when not and how to retrieve data sets efficiently.  The LET function and LAMBDA functions are used, and more recent functions will be required including the array manipulation functions.The sample model built will include user-controlled settings that dynamically changes the number of periods forecast, the number of months per period, building a truly flexible forecasting tool with surprisingly few formulas!

It would be familiar with modelling concepts and be able to absorb the workings of new and unfamiliar functions.  Some familiarity with LET and LAMBDA would be an advantage, but their use will be covered in this module..