by Nate Moore | Oct 10, 2011 | Functions
Watch Excel Video 199 to see two quick ways to better understand the formulas on your spreadsheet. The first trick is Show Formulas, a quick way to show all of the formulas on a spreadsheet. Holding down the control key and the key with ` and ~ (tilde) on it is a...
by Nate Moore | Oct 5, 2011 | Functions
I can’t help you with your shortstop’s errors, but Excel Video 198 will try to fix your spreadsheet’s errors. We’ll talk about a couple of Error Checking tools today. You’ll see how the Error Checker works and how Trace Errors is a lot like tracing precedents and...
by Nate Moore | Oct 3, 2011 | Functions
Need a crystal ball with a rear view mirror? Watch Excel Video 197. Excel Video 197 starts our discussion of Excel’s Formula Auditing tools. Precedents are like the rear view mirror. Trace Precedents will show you the past, the cells that combine to create the cell...
by Nate Moore | Sep 28, 2011 | Functions
Want to RANK higher in your Excel knowledge? Watch Excel Video 196. Excel uses RANK functions to show how items rank in a list. You can rank either descending (highest to lowest) or ascending (lowest to highest) and descending is the default for both functions. Watch...
by Nate Moore | Sep 26, 2011 | Functions
There are a LARGE number of ways to use these two functions and it only takes a SMALL amount of time to learn about them in Excel Video 195. MIN is an easy Excel function that takes the smallest value in a list. What if you want the third smallest value for a...