by Nate Moore | Oct 12, 2011 | Functions
We’ve made it all the way to Excel Video 200. Thanks to each of you watching and for spreading the word about the videos. Today we’ll finish our discussion of the Formulas tab by introducing the Watch Window. The Watch Window helps you keep track of a value in a...
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...
