How to use the Excel OFFSET function

Thanks! Share it with your friends!

Close

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.

Comments

Write a comment

*

 
  Advertisement
Skip Ad
Skip Panel
 
Skip Survey
Test
Name
Email
×
It would be awesome to hit "like" or "share" and start playing.