Student Reviews
( 5 Of 5 )
1 review
Video of Data Validation in Excel Drop-down lists FREE Excel Course in Excel for Finance & Accounting course by TrumpExcel channel, video No. 18 free certified online
In this video, I will cover all you need to know about data validation and drop-down lists.
Download File - https://trumpexcel.com/course-download-files/
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)
Download File - https://trumpexcel.com/course-download-files/
If you find 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?vUPABcYhugZk&listPLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6
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_confirmation1
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial