Use the OFFSET function for tabulating moving data

- [Voiceover] Excel has an unusual function called offset.…If you go to the formulas tab in the ribbon,…you might have discovered it if you click…the Look Up and Reference portion…and you will see Offset, its description,…Returns a reference to a range that is a given number…of rows and columns from a given reference.…That gives you some sense of the capabilities,…but let's show it in a real life example.…On this worksheet I've got a list in column A.…It's been converted to a table.…It's not a prerequisite for what we are about to do here,…but it does suggest the idea that we've got…a chart to the right, and as the data grows,…the chart will expand automatically.…

We're tracking data for nearly every day of the year here.…Except for certain holidays, there are sales every day.…The list is grown.…If I click on any cell in the list…and double click the bottom edge,…you'll see that currently we've got data through May 15th.…So let's say we update this, if not necessarily every day,…update it every few days so that we have all of our totals…