Data Validation in Excel | Drop-down lists | FREE Excel Course

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)

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.

⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[manishsoni]

I must say that you have provided a very good excel course for free. Generally, people don't do that. Thanks a lot

[IndikaSugathapala]

You'r a real Teacher, i should say truly '''never seen a man like you before... true logic (not joking really )

[ellisiverdavid]

A wise man once said:

"𝑻𝒂𝒍𝒌𝒊𝒏𝒈 𝒂𝒃𝒐𝒖𝒕 𝒊𝒕
𝒅𝒐𝒆𝒔 𝒏𝒐𝒕 𝒎𝒂𝒌𝒆 𝒔𝒐 𝒎𝒖𝒄𝒉 𝒔𝒆𝒏𝒔𝒆
𝒂𝒔 𝒔𝒉𝒐𝒘𝒊𝒏𝒈 𝒊𝒕."
— Bansal, S. (2014, 17:44)

And this profound truth applies to thesis defense presentations, job screenings, promises of "change for the better", "I'll pay you later", and in love and relationships! 😂
Almost everything manifests a clearer sense when there's "more than words" to prove things.
Simply brilliant ✨

[wayneedmondson]

Hi Sumit.. great lesson and review of Data Validation tips and techniques. Thanks for sharing this video series.. very helpful. Thumbs up!

[praveenrajarapu]

Thank you so much sumith you have explained crystal and clear way..

[iliesboukhatem]

very useful tutorial, thank you so much !

[MOHAMMADASEFHOSSAINIMSC]

Excellent work, thank you so much sir.

[prashantkumar]

You can simply make a dynamic drop down list just by selecting extended range and by allowing ignore blank cells. simple, and it works the same

[couragetamakloe]

Thank you, Sumit. I really enjoy your lessons. How do I stop Excel from flashfilling when I use an offset formula? For example, when I use this formula (=OFFSET($O$8, 0, 0, COUNTIF($O$8:$O$17, "<>"&"")) Excel flashfills all the bottom rolls. I turned off automatic flashfill but I'm still getting the same results.

[GoGetSP]

29:42, you discussed the same and it gave an error, why if OFFSET formula giving 2011? thanks Sumit, watching you from Brazil.

[amolpathak]

You are doing a great job..but by going into too deep by mixing several formulas confuses the beginner level student.

[balwinderlal]

You should explain more brief about formulas in excel ur recent excel formula videos needs more clarification....

[kirandeepchoudhry]

Nice video Trump bro, Can you please make video on income tax calculation for assessment year 2019-20.

[monicahasija]

Can we make dynamic drop-down by using index function?

[viscaelbarca]

I didn't get what you have done after 20th minute, I mean not complaining just didn't understand.

[heeyaboruah]

Does anyone find it odd I am in grade 7, 12 years old, going through school stress yet learning another thing, Excel, and learning excel formulas, trying to find a job for excel after I finish next month but all this just for the knowledge and fun of knowing about how to so called learn about the "hardest thing to learn"? Well I do...

[GoGetSP]

at 30:35, when I am using List as Validation Criteria I am able to do Data Validation but with Custom as Validation Criteria, it's not happening? why is that?

[GoGetSP]

AT 5:18, 12345 LEN = 5? THEN WHY RESTRICTED?