As the creator of an Excel workbook, it is your primary responsibility to ensure that the data in the worksheets have 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 proliferate 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 ...
© David Slager and Annette Slager 2020
D. Slager, A. SlagerEssential Excel 2019https://doi.org/10.1007/978-1-4842-6209-2_99. Auditing, Validating, and Protecting Your Data
Get Essential Excel 2019: 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.
