Check out this video for a quick data validation overview.
You can download an example workbook with all of the data validation examples you'll find in this article.
The standard operating system used throughout industry for spreadsheet applications is Excel.
Excel is a well used and known system with millions of programs in use word-wide. However applications that run on Excel do require to be validated.
If the spreadsheet is signed off and dated by the user, their supervisor and QA, it becomes regulatory acceptable data stored in hard-copy, and Part 11 does not apply.
Having taken Part 11 out of the great debate; what remains.
All true, but none of these problems interfere with your ability to validate that the spreadsheet is fit for purpose.
They only preclude you from using the spread sheet as a compliant repository for any data that has to be stored in compliance with 21 CFR Part 11 .You can follow along, or create your own data validation scenarios.Download Excel data validation examples Now, instead of typing your list values in the data validation Source box, you add the name that you just defined, preceded by an Equal (=) sign.You can use data validation to restrict the type of data or the values that users enter into a cell.One of the most common data validation uses is to create a drop-down list.Then use our spreadsheet validation qualification pack to validate them. On one audit, where the client stated they had four critical spreadsheets to be validated, their network was searched and 212 spreadsheets were found.