Excel Formula Errors & Auditing: #N/A, #VALUE!, #REF! and How to Fix Them
Repair broken reports: #DIV/0!, #N/A, #VALUE!, #REF!, #NAME? and #NUM!, classify errors with ISNA and ISERR, find totals that silently don't add up and build check cells with red flags, in 8 hands-on labs at one company.
The first 2 lessons are free — no account needed.
About this course
An Excel formula errors and auditing course that repairs the broken reports of one fictional office-supply company, for analysts, accountants and anyone who inherits other people's spreadsheets. You fix #DIV/0! with an IF test or IFERROR without letting a fake 0% drag down an average, trace three #N/A lookups to a stray space, a number stored as text and a code that really is missing, find the text hiding behind #VALUE!, repair #REF! and references that broke when a formula was copied, correct the typos and unquoted text behind #NAME? and the impossible maths behind #NUM!, label and count errors with ISNA, ISERR and ERROR.TYPE, find totals that are wrong without any error code and finish with a model audit panel of check cells and red flags. The first two labs are free.
Lessons
- #DIV/0! & Safe Division: IF Tests vs IFERRORFree
- #N/A from Lookups: Trailing Spaces, Numbers Stored as Text & IFNAFree
- #VALUE!: Text in Arithmetic, VALUE & SUBSTITUTE Pro
- #REF! & Broken References: Deleted Cells, Relative vs Absolute after Copying Pro
- #NAME? & #NUM!: Typos, Unquoted Text and Impossible Maths Pro
- ISERROR, ISERR, ISNA & ERROR.TYPE: Classify and Count Errors Pro
- Totals That Don't Add Up: Text Numbers, Double Counting & Check Sums Pro
- Model Audit Checklist: Check Cells & Red Flags Pro