Video Lesson: Error Checking & Data Monitoring

Error Checking and Data Monitoring in Excel

In the following video tutorial, I go over the following items in detail:

Explanation and example of major error types in Excel:

#DIV/0 — #VALUE! — #REF! — #NAME? — #NUM! — #N/A — #NULL!

Overview of Excel’s built-in error checking options and functionality.

How to use “Go To Special…” to find errors easily.

Copy / paste large data areas for data monitoring.

Using direct comparison, and SUM/COUNT functions to compare data changes.

Use of Conditional Formatting for emphasis when comparing ranges.’

Download the Error and Data Checking file to follow along with the video lesson!

This entry was posted in Data Input & Manipulation, Workbook/Reference Lessons. Bookmark the permalink.

8 Responses to Video Lesson: Error Checking & Data Monitoring

  1. mysty says:

    Hi,

    Which Formula did you use to capture the exact data (in Error Check Sheet) from another worksheet(Order Data Worksheet)?

  2. Mihaela Manu says:

    For Leyla,
    I’m afraid is to late to answer to your question , I did this using conditional formatting /highlight cells rules / equal to true- with-
    choose custom format /font color -red then fill/pattern color -automatic.
    Best regards
    Bobo

  3. Leyla says:

    Hello Ben!
    Could you please tell me how to highlight true and false cells to red anf green?
    Thank you!

  4. Anonymous says:

    Thanks for this vid, will definitely be using the ‘IFERROR’ formula, will tidy up a lot of my spreadsheets.

  5. Anonymous says:

    Thank you much! I always have struggled with Excel sheet comparisons. Now I know it’s a piece of cake.

  6. Anonymous says:

    This video stopped playing after 8:45.

Comments are closed.