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 ...
© David Slager 2016
David Slager, Essential Excel 2016, 10.1007/978-1-4842-2161-7_9
9. Auditing, Validating, and Protecting Your Data
David Slager1
(1)Fort Wayne, Indiana, USA
Get Essential Excel 2016: A Step-by-Step Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
