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 [More]
The Quick access toolbar is the floating toolbar that sits above the Ribbon bar in Excel 2007 and Excel 2010. The Quickaccess toolbar is often overlooked by the user but this video will show you just how easy it is to add or remove buttons from this toolbar so that you can make all your commonly used functions in Excel accessible without moving between ribbons. The video will also show you how to use separators to make the buttons easier to see and how you can change the location of the Quick access toolbar. Watch the video then use the [More]
Skip Ad
Skip Panel
Skip Survey
It would be awesome to hit "like" or "share" and start playing.