[go: up one dir, main page]
Scribd
Upload
41 views4 pages

Financial Model Error Checks & Protection

This document discusses accuracy checking and data protection in financial modelling. It identifies common errors in modelling like input errors, omission errors, and calculation errors. It also describes error values like #VALUE! and #REF! that can help debug models. The document outlines audit tools like the audit toolbar and watch window to check for structural issues, as well as techniques for protecting data through cell, worksheet and workbook permissions.

Uploaded by

Neha Jose
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
41 views4 pages

Financial Model Error Checks & Protection

This document discusses accuracy checking and data protection in financial modelling. It identifies common errors in modelling like input errors, omission errors, and calculation errors. It also describes error values like #VALUE! and #REF! that can help debug models. The document outlines audit tools like the audit toolbar and watch window to check for structural issues, as well as techniques for protecting data through cell, worksheet and workbook permissions.

Uploaded by

Neha Jose
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

Financial Modelling:

Accuracy Checking &


Data Protection
Neeraj Amarnani
Goa Institute of Management

Data Validation
Used to restrict to / warn against use of
particular data in cells
Can use various types of input restrictions
Can input data in a range, list
Could be numbers, text

- Prepared by Neeraj Amarnani

Errors in Modelling
Taxonomies of Errors
Pointing errors
Input errors
Omission errors
Commission errors
Calculation errors
Timing errors
Domain errors

Error Values
Typical Errors
#VALUE!
#REF!
#NAME?
#DIV/0!
#NUM!
#N/A

Debugging errors
Auditing, Structural Checks

- Prepared by Neeraj Amarnani

Audit Tools
F2 Edit Cell

Audit Toolbar
View Formulas
F9
The Watch Window
The Special function: Go To Special

Circular References

Structural Checks
Location of inputs

Errors

Hardcoded values

Hidden columns and


rows

References to Blank
cells
Left-to-right
consistency

Hidden sheets
Merged Cells

Array formulae

File Links

- Prepared by Neeraj Amarnani

Protecting Data
Protection possible for
Cells
Worksheets
Workbooks

Access to Workbooks can be restricted


Password to Open
Give Read Only Access

- Prepared by Neeraj Amarnani

You might also like