Select Page

New Excel Mastery VLOOKUP page

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...

Absolute vs Relative References in Excel

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...

Excel Video 200 Watch Window and Calculation Options

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...

Excel Video 199 Showing and Evaluating Formulas

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...

Excel Video 198 Error Checking

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...

Excel Video 197 Tracing Precedents and Dependents

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...