Selecting a range of data dynamically in Excel is just cool!  It allows us instantly to update data analyses at the click of button by instructing Excel to look at a particular part of a dataset.  Dynamic data selection mechanisms are at the heart of all the Excel dashboards I build.

For the football trader, dynamic data selection in Excel allows you to answer questions such as 'what was performance of this system in this particular month?' without having to dip into the data yourself with a technique such as filtering.

In this video, I show how I use the INDIRECT formula to get Excel working with data dynamically.  I walk you through the whole process, including the other formulae required to get this powerful mechanism working.

Tools and Techniques