How to use Data Validation in Excel: Complete Guide.
In this video tutorial, we learn how to use data validation to restrict invalid data entries in Excel. With Microsoft Excel Data validation, we can control and validate user inputs inside our worksheets. Technically we create validation rules that control which kind of data can be entered into a certain cell or a range of cells and this helps us collect accurate raw data.
00:00 What is Data Validation?
00:02 How many types of Data Validation do we have?
02:24 How to use the Whole number data validation criteria
04:49 How to customize Error Alert message inside data validation
08:44 Data validation error alert (STOP)
10:55 Data Validation error alert (WARNING)
13:20 Data Validation error alert (INFORMATION)
13:55 How to customize data validation error alerts
21:48 How to create a dropdown list in Excel
Thanks for watching!
![Introduction to Power BI DAX formulas for Complete Beginners [Live Online Class]](https://images.videosashka.com/watch/dYuVq0pR4Hs)
