Channel | Publish Date | Thumbnail & View Count | Download Video |
---|---|---|---|
Publish Date not found | 0 Views |
Data validation allows you to ensure that all data entered into a cell meets certain criteria (that is, it is first validated and then accepted).
For example, if you want a cell to only accept date values, you can specify this in data validation. Or if you want to only accept numbers up to 10 digits, you can specify this in data validation.
Dropdown lists are part of data validation because they give the user the option to select from a pre-populated list. This can be very useful if you have a workbook that you want users to enter data into, or if you are creating an Excel dashboard.
The video covers all the basic topics of data validation and then also some advanced topics of data validation – like dependent dropdown lists, input messages, dynamic dropdown lists, etc.
It covers the following topics:
— Data validation criteria
— Input message
— Customizing error messages
— Circle invalid entries
– Advanced data validation tricks (e.g. create dependent validation, create subheadings in validation, hide numbers as text, create dynamic dropdown list)
If you find the videos useful and want to support me, you can buy me a coffee – https://www.buymeacoffee.com/SumitB
This video is part of my free online Excel training where I show you the basics of using Excel and also cover many advanced topics.
For more details about this free Excel training and download files, please visit: https://trumpexcel.com/learn-excel/
You can also access the full Excel training here on YouTube: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6
Free Excel Course – https://trumpexcel.com/learn-excel/
Paid online training – https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/
️ Equipment I recommend:
Camera – https://amzn.to/3bmHko7
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB microphone – https://amzn.to/2uzhVHd
Wireless microphone: https://amzn.to/3blQ8uk
Lighting – https://amzn.to/2uxOxRv
Subscribe to get great Excel tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1
Note: Some of the links linked here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Please take the opportunity to connect with your friends and family and share this video with them if you find it useful.