Error Correction in Excel
CLASS DATE(s):
8/20/2020
8/21/2020
9/18/2020
10/15/2020
11/12/2020
11/13/2020

COURSE LENGTH: 1/2

COURSE COST: $99

COURSE TIMES: 9:00am - 1:00pm

Printable version of this course
print
Register for this course
register

COURSE OVERVIEW

Excel has many tools to help you choose the correct formula, enter it, and inspect it after you're finished. There are even tools to guard against certain errors that users might commit. This is a hands-on session to build confidence in the workbooks you create.

AUDIENCE AND PREREQUISITES

This course is intended for people who want to improve their function writing skills, be certain their formulas are accurate and accomodate irregularities and user errors. Students should have a thorough grasp of writing formulas and using functions.

PREREQUISITE COURSES  

*Course Cost listed does not include the cost of courseware. Course is subject to a minimum enrollment to run the course. Course may run virtually as a virtual live instructor led class if the minimum enrollment is not met. For more information, please contact: 207-775-0244 or email: learn@vtec.org.

COURSE TOPICS:


Module 1: Avoiding errors on input
Entering formulas with mouse, keystroke, arrow keys
Redundant formulas
Duplicating formulas with autofill, copy/paste, fill down & right
Using the formula wizard

Module 2: Edit and correcting formulas
Formula bar, double click, F2
Show formulas tool

Module 3: Absolute/Relative reference review

Module 4: Error checking
Inconsistent formula
Enable background error checking
Error-Checking tool

Module 5: Built-in Tools
Evaluate formulas
Trace-precedent/trace-dependents
Watch window

Module 6: Formulas
IF( )
ERROR.TYPE( )
IFERROR( )
FORMULATEXT( )