The use of dynamic references, dynamic names, advanced conditional expressions, array formulas is canvassed in this session. Techniques to avoid redundant calculations which directly impact on model size and performance are discussed and demonstrated. It also presents techniques for working with formulas to build more flexible analyses of data and structuring workbooks to facilitate these analyses.  Summary and cross-tab reports using dynamic array formulas are demonstrated.

Participants should be familiar with more complex formulas such as MATCH, INDEX, and SUMIF and have some knowledge of array formulas. Completion of one of the pre-requisite modules or courses is recommended.