Auditing, Validating, and Protecting Your Data

Abstract

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 tools to help you prevent errors from getting into your workbooks, but it is up to you to incorporate them.