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!

Trả lời

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *