About Course
Learn what each Excel error value means and how to fix the cause rather than hide it. The course covers #DIV/0!, #N/A, #NAME?, #REF!, #VALUE!, #NUM!, #NULL!, #SPILL!, #CALC! and ####, plus when it is appropriate to use IFERROR, IFNA and XLOOKUP’s “if not found” option.
Tutwoo is an independent learning provider and is not affiliated with or endorsed by Microsoft. Menu names and features can vary between versions and platforms and change with updates. This course is general skills training and is not an accredited qualification.
Course Content
Course Lessons
-
The calculation errors: #DIV/0!, #VALUE!, #NUM! and ####
-
The reference and lookup errors: #N/A, #NAME?, #REF! and #NULL!
-
The dynamic array errors: #SPILL! and #CALC!
-
Handling errors responsibly
Sources & Further Reading
Final Assessment
Student Ratings & Reviews
No Review Yet