Excel Business Analytics Free Course - Forecasting, Linear Programming, Simulation & more. Basic Excel Business Analytics #10: Find & Fix Excel Formula Errors in Spreadsheet Models
Basic Excel Business Analytics #10: Find & Fix Excel Formula Errors in Spreadsheet Models Transcript and Lesson Notes
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 Do
Quick Summary
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 Do
Key Takeaways
- Review the core idea: 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 Do
- Understand how Excel fits into Basic Excel Business Analytics #10: Find & Fix Excel Formula Errors in Spreadsheet Models.
- Understand how Microsoft Excel fits into Basic Excel Business Analytics #10: Find & Fix Excel Formula Errors in Spreadsheet Models.
- Understand how Highline College fits into Basic Excel Business Analytics #10: Find & Fix Excel Formula Errors in Spreadsheet Models.
- Understand how Mike Girvin fits into Basic Excel Business Analytics #10: Find & Fix Excel Formula Errors in Spreadsheet Models.
Key Concepts
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
Lesson FAQs
What is Basic Excel Business Analytics #10: Find & Fix Excel Formula Errors in Spreadsheet Models about?
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 Do
What key concepts are covered in this lesson?
The lesson covers Excel, Microsoft Excel, Highline College, Mike Girvin, excelisfun.
What should I learn before Basic Excel Business Analytics #10: Find & Fix Excel Formula Errors in Spreadsheet Models?
Review the previous lessons in Excel Business Analytics Free Course - Forecasting, Linear Programming, Simulation & more., then use the transcript and key concepts on this page to fill any gaps.
How can I practice after this lesson?
Practice by applying the main concepts: Excel, Microsoft Excel, Highline College, Mike Girvin.
Does this lesson include a transcript?
Yes. The full transcript is visible on this page in indexable HTML sections.
Is this lesson free?
Yes. CourseHive lessons and courses are available to learn online for free.
Continue Learning
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
