If you are going to create Excel Dashboards you will need to fully understand how the Excel Offset command works. The video looks at ways that the command can be used to return values from a list of data based on other values in the spreadsheet. This is commonly used on graphs that allow you to set a date range to plot dynamically.
This is one of the original Improve Your Excel videos and you can download the XLS file used in this video by clicking here.
To download 47 videos just like this one together with the files used in each demo – find out more here.