Join Dennis Taylor for an in-depth discussion in this video Use the OFFSET function for tabulating moving data, part of Excel Tips Weekly.
- View Offline
- [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…
Skill Level Appropriate for all
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.