Creating interactive reports with dynamic arrays - some practical examples

In this session, Jess will present a selection of ways to make your reports more interactive using some of Excel’s newer formulas.

Using a series of worked examples she’ll provide practical ideas for how dynamic array formulas such as FILTER, UNIQUE, TAKE and GROUPBY could revolutionise how you present management information, with a particular focus on interactivity.

The demonstration will use real life examples that you can reuse and adapt for your needs, while also discussing the principles behind these powerful new formulas.

This session is suitable for anyone who prepares management information for others; no prior knowledge of dynamic arrays is necessary.