by Nate Moore | Mar 14, 2011 | Functions
Excel Video 139 provides an overview of the Formulas tab in Excel 2010. For the next set of Excel Videos, we’ll cover a wide variety of functions that will do everything from statistics to finances to telling you what time it is. I won’t go through every single...
by Nate Moore | Mar 9, 2011 | Charts
Excel Video 138 adds the finishing touches to our scrolling chart. Today we’ll add the scroll bar. To add the scroll bar and other programmable items to your spreadsheet you need to have the Developer tab displayed. If you’re in Excel 2010, I’ll show you the box to...
by Nate Moore | Mar 7, 2011 | Charts
Excel Video 137 uses the named ranges we created in the last Excel Video to update our charts’ data sources. We’ll start with the top chart. We need to change the data we’re plotting to be the named range Collect2 and the horizontal axis to look at the named range...
by Nate Moore | Mar 2, 2011 | Charts
Excel Video 136 takes advantage of the OFFSET tricks I discussed starting with Excel Video 85. If you missed those videos or it’s been a while since you’ve used OFFSET, spend a few minutes watching the videos starting with Excel Video 85. The beauty of OFFSET is that...
