by Nate Moore | Jun 11, 2015 | Functions
I just added a new Excel Mastery page covering VLOOKUP to my website. The VLOOKUP article has been my most popular article and comes with a sample spreadsheet to follow along with the article and practice. You’ll also find a set of VLOOKUP videos to watch. If...
by Nate Moore | May 20, 2015 | Functions
I’ve posted another free article on my website. Today’s topic is Absolute vs Relative References in Excel. Spreadsheets are great at being able to create one formula and copy it hundreds or thousands of times. Many times that copy and paste is good...
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...
