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!

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

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