As highlighted in previous posts spreadsheet errors are receiving increasing exposure in the real world.
You can now watch a video clip from CNBC explaining some of the biggest errors the world has seen and emphasizing that 88% of spreadsheets have errors. Some of the resulted errors run into billions of dollars and are due to fundamental problems with the way spreadsheets are developed and used.
To see how easy it is to make these errors watch the video clips below.
- Insert a cell error
- Delete a cell
- Links between workbooks error
- VLOOKUP error types
- Spaces in IF, SUMIF, COUNTIF, VLOOKUP etc
- Absolute and Relative References errors
- Hidden Rows or Columns
- Excel sees blank and Human assumes zero