Dave Bruns

In this video we'll look at how to set up a VLOOKUP formula to avoid #N/A errors...

In this video we look at a few reasons why VLOOKUP is a better option than nested IF statements.

It can sometimes be difficult to know what is causing formula errors. In this video, we'll look at how to track down the source of a formula error in Excel...

When you use Excel frequently, you're likely to see a number of potential errors flagged on the worksheet as you work. In this video, we'll review the error checking options for formulas in Excel. ...

In this video, we'll walk through each of the error codes that Excel displays when there's something wrong with a formula. We'll also look at some simple ways to resolve the errors...

In this video, we'll look at a few examples of the kinds of errors that Excel will flag on a worksheet and the rules that control which errors are flagged...

In this video we'll look at how to quickly find formulas and trace how they are related to one another using the concept of precedents and dependents...

Trapping errors can make your spreadsheets more professional by making them less cluttered and more friendly to use. In this video, we'll look at some ways to trap errors in a formula...

In this video we look at several options to enter a current date and time in a worksheet. ...

Excel contains special functions that will let you extract the day, month, and year from a valid date.