Data-validation is a tool in Excel that is a great way to avoid making mistakes when inputting data. Anybody who has ever done any data collection knows the headache of have to fix data entry errors. These mistakes can have a sever impact on the analysis and conclusions that analyst makes. The video below demonstrates how to implement data validation in Excel.