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
How To Check For Errors
6:57 with Tyler TallonIt’s impossible to prevent all errors, so let’s take a look at some ways that we can check for errors.
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
But the data validation is not perfect and
it's impossible to prevent all errors.
0:00
So let's take a look at some ways
that we can check for errors.
0:01
One thing I often do is create
a separate check formula.
0:05
Here we have our store sales again
by state and product and a total for
0:08
these states.
0:12
What we can do now is add totals
to the bottom for Product A and
0:13
Product B and then get a product total.
0:18
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