© David Slager 2016

David Slager, Essential Excel 2016, 10.1007/978-1-4842-2161-7_9

9. Auditing, Validating, and Protecting Your Data

David Slager

(1)Fort Wayne, Indiana, USA

As the creator of the Excel workbook, it is your primary responsibility to ensure that the data on the worksheets has been entered correctly. You may not have control of the source of the data, but it is your responsibility to ensure that you enter the data you are given without error. Poor data and incorrect entries can ruin a business. Errors made in one location may be propagated to other areas in the workbook. Users may be incorporating the data from your workbooks into their own projects or they may be using your workbooks to base their decisions on. Excel provides several ...

Get Essential Excel 2016: A Step-by-Step Guide now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.