Data validation is an extremely important activity in the loading and maintaining of any decision support system because the basis of sound reporting and decision making is accurate, timely data.
This pronouncement should not come as a surprise to anyone, and any data manager worth his or her salt knows this implicitly.
You can also use data validation functionality to create an Excel drop down list (which is definitely one of the coolest and most powerful features in Excel) Data Validation in Excel can be accessed through the Data tab in the Ribbon.
In most cases, there are three situations where you would want to use Data Validation in Excel: Data validation allows you to specify a condition for data entry in a cell/cells in Excel.
The rules may be implemented through the automated facilities of a data dictionary, or by the inclusion of explicit application program validation logic.
Data validation is intended to provide certain well-defined guarantees for fitness, accuracy, and consistency for any of various kinds of user input into an application or automated system.
This makes it impossible, or at least much harder to extract information like how much customers from the United States have used your webshop, and how many from India..
And what would happen if your database didn't check the minimum length of a phone number?
Imagine a webshop database that would allow you to enter a new customer without an address.
You would be unable to ship goods to such a customer.
Data validation is important, because it ensures the usefulness of your data.