Ever been hounded by the thought of data entry errors. Simple Mistakes and even plain simple mistakes can wreck havoc on the data analysis.
If you have a defined number of options to choose from and enter then the data validation option comes to the rescue.
Example:
Entering the Date, Month and Year in 3 different Columns.
Date: Can be made to choose from 1-31
Month: Can be made to choose from Jan-Dec
Year: Any logical defined Range can be Taken.
How To:
Navigate to the Data Tab>Data Validation
Thats it. This way you restrict users to select values between the defined range only.
There are a number of other options also.
Please ping me for any specific details you might require.
Thanks Again.
