Create SMART Drop Down Lists in Excel (with Data Validation)

Показать описание

Learn the art of creating dynamic drop-down lists and implementing advanced data validation. Whether you're managing projects, handling company data, or just looking to improve your Excel skills, this video is packed with valuable insights.

🔍 What You'll Learn:
▪️Dynamic Drop-Down Lists: Discover how to create drop-down lists that update automatically with new entries.
▪️Data Validation Techniques: Learn to validate dates, numbers, text length, and more, ensuring data accuracy and consistency.
▪️Practical Examples: Follow along with real-world scenarios, like managing project details across different divisions of a company.
▪️Expert Tips: Gain tips on using cell references, Excel tables, and custom functions for robust data validation.

★★ Links to related videos: ★★

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel

Рекомендации по теме

Комментарии

May I just say how wonderful it is to find a content creator who takes their time explaining and referencing each step! From the bottom of my heart ❤ THANK YOU! 😊 💓

whocares

Hi Leila, always a pleasure when you explain thing s so clearly. I am a community health worker and I use validation for collecting data. Your videos help to clarify and organize my data. 👍😊💖

hectoralicea

The most complete Data validation tutorials you ever need at one place.

s.n.g.

Leila, you have mastered on what you do. Thank you.

eticollege

I have been using Excel drop-down lists for years and I STILL learned several new things. Thank you so much. That was wonderful. I think I will try that searchable drop-down list video next!

kennethpaige

I just love you Leila! Thanks for sharing such valuable information and in such a simplex manner. Kudos!

siddish

As usual you add just another extra layer to excel functions I thought I already master:) It's always worth it to watch your basic videos no matter how advanced you are! Thanks Leila!

weblady

I've been using data validation for a long time but this is a comprehensive tutorial that has taught me more than I knew. Thanks so much, Leila. You're the Queen of Microsoft Excel.

euniceesinam

I wish I had learned this when I was younger. I am 55 and working with time sheets and this could really help me. Your information is helping me understand slowly I will try to lean as much as I can. 😊 Thank you.

jayrhoads

Brilliant - as always when Leila delivers work. I use validations frequently and still learned a ton watching your video. Thank you for all your hard work - you really are making a difference!

HubertKirchgaessner

I am a project manager and so need this for recording the tasks I delegate to my people. I just watched the other video you made about the IF formulas, and it's very helpful in making a table for our employee's Key Performance Indicators (KPI). Thank you so much!

Monica-hzdk

Great. I was looking for the way to include automatically data in the drop sown today I got it. I tried without formatting the range into Excel table, it works well. I just include the whole the column in the range and use it in the data validation with Indirect. Thanks once again Leila.

luisedy

Thank you for the nice refresher Mrs Leila Gharani!

saidaselhaoui

Hi Leila, Love your tutorials! I am new to Excel but I am learning a lot thanks to your YouTube Channel! You are my go-to source when I run into a problem! Thanks Again! Please Keep Up the Good Work!!!

tamariwatkins