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!

About these ads

7 thoughts on “Video Lesson: Error Checking & Data Monitoring

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

Post any comments, feedback or questions below!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s