Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Data Validation in Excel | Drop-down lists | FREE Excel Course. That video is uploaded by TrumpExcel at 2019-05-18T01:05:52-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [e29MMixNycI]
| Name | Data Validation in Excel | Drop-down lists | FREE Excel Course |
| Video Uploader | Video From TrumpExcel |
| Upload Date | This Video Uploaded At 18-05-2019 08:05:52 |
| Video Discription | In this video, I will cover all you need to know about data validation and drop-down lists. Data validation allows you to make sure any data that is entered in a cell meets specified criteria (i.e, it's first validated and then allowed). For example, if you only want to make a cell accept date values, you can set that in data validation. Or if you only want to accept numbers up to 10 digits, you can specify that in Data Validation. Drop Down Lists are a part of data validation, as it gives the user an option to select from a pre-populated list. This can be really useful when you have a workbook where you want people to do data entry or when you're creating an Excel dashboard. The video covers all the basic data validation topics and then also covers some advanced data validation topic - such as dependent drop-down lists, input messages, dynamic drop-down lists. etc. It covers the following topics: -- Data Validation Criteria -- Input Message -- Customizing Error Messages -- Circle Invalid Entries -- Advanced Data Validation Tricks (such as Create Dependent Validation, Make Sub Headings in Validation, Disguise Numbers as Text, Creating Dynamic Drop Down List) ☕ If you're the videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics. You can find more details about this Free Excel Training + the download files here: https://trumpexcel.com/learn-excel/ You can also access the Full Excel Training on YouTube here: 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/ ⚙️ Gear I Recommend: Camera - https://amzn.to/3bmHko7 Screen Recorder - techsmith.z6rjha.net/26D9Q USB Mic - https://amzn.to/2uzhVHd Wireless Mic: https://amzn.to/3blQ8uk Lighting - https://amzn.to/2uxOxRv Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1 Note: Some of these links here are affiliate links! #Excel #ExcelTips #ExcelTutorial e29MMixNycI |
| Category | Education |
| Tags | Excel Data Validation | Excel Drop Down Lists | Data Validation Criteria | Data Validation Error Message | Advanced Data Validation | Learn Excel | excel data validation list from table | excel data validation list | data validation multiple criteria | data validation criteria in excel | advanced excel | excel basics | excel tips | excel tutorials | free excel training | free online excel training for beginners | learn excel | sumit bansal | trump excel | excel for beginners |
