Summary
Keywords
Full Transcript
Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm Learn how to Tracking Down Cause of Spreadsheet Model Formula Errors & Fixing Them: 1) (00:12) 6 Step list for Tracking Down & Fix Excel Formula Errors (6 step solution process) 2) (00:41) Example of the 9 types of Formula Errors you may see: #DIV/0!, #REF!, #NAME?, #N/A, #VALUE!, #NULL!, #NUM!, #######, Circular Cell Reference 3) (03:59) Discuss 6 Steps 4) (04:37) Example of Six Formula with errors and how to fix them. 5) (12:34) Example of Two-Way Look Formula that has many errors. We fix all of them! 6) (16:32) Trace Precedents Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video. 6 Step list for Tracking Down Excel Formula Errors: 1. F2: Is formula correct? 2. F2: Cell References Correct? 3. Trace Precedents? 4. Are formula inputs & raw data correctly entered? 5. Formula Evaluator? 6. F9 key. Types of Errors: #DIV/0!, Divide by zero #REF!, Formula is using cell reference that has been deleted, or other invalid cell reference #NAME?, Excel built-in function misspelled, Defined Name misspelled, or "text" (word data) in formula is not in double quotes. #N/A, Not Available/ No Answer #VALUE!, Invalid operand or argument type (argument in a function), or Array Formula was entered without Ctrl + Shift + Enter #NULL!, No Intersection #NUM!, Invalid numeric values in a formula or function, or an iterative function like IRR cannot find an answer, or the number is too big or small (number must be between -1*10^307 and 1*10^307) #######, Column width not wide enough to display data (values), or negative date or time Circular Cell Reference, Cell reference in formula refers to the formulas result (itself). You see a dialog message about this error
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
