Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed Intermediate Excel!
You have completed Intermediate Excel!
Preview
Why Error Checking Is Important
3:04 with Tyler TallonNow let's learn about the importance of error checking and look at some effective ways to check your work.
Downloads
Please note that this is a new spreadsheet, different from the one you used in the previous stage:
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
[MUSIC]
0:00
So far in this course we've learned
how to use look up functions,
0:00
create a pivot table, and learned how
to use several other tools in Excel.
0:04
Now we're going to learn about
the importance of error checking,
0:08
which has saved me so many times.
0:11
And I'm excited to show you some
effective ways to check your work.
0:13
Before we dive in to
the error checking process,
0:17
let's first discuss some
common errors in Excel.
0:20
Generally, there are four
different types of errors.
0:23
Input errors, which are data
entry errors or missed data.
0:26
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up