Sometimes you might create named ranges after you've already built formulas. In this video we'll look at how to apply named ranges to an existing formula...
In this video we'll look at how to create a dynamic reference to a named range with the INDIRECT function. This is one way to switch ranges on the fly...
In this video we'll take a quick look at the information provided by the status bar. The status bar provides real-time data about currently selected cells and can give you a lot of useful information.
...
Excel won't let you save a formula that isn't working. In this video, we'll look at a simple way to save an unfinished formula so you don't lose your work...
In this video we'll look at a way to quickly add missing data to a worksheet. It's a simple technique using a very basic formula and a cool example of relative cell references...