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

Рет қаралды 832,216

Күн бұрын

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
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.
Full Article: www.xelplus.com/data-validati...
★★ Links to related videos: ★★
Indirect Function: • Excel INDIRECT Functio...
Dependent data validation lists: • Dependent Drop-Down Li...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
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

Пікірлер: 579

@whocares4684 2 жыл бұрын

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! 😊 💓

@Jalalmaher1983 3 жыл бұрын

You deserve the Excel Throne!

@freefirek-series6487 3 жыл бұрын

kzfaq.info/love/tNr753qbiVw61oY_ow_aPw New channel need your valuable support 🙏❣️😇😍

@s.n.g.888 4 жыл бұрын

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

@siddish03 4 жыл бұрын

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

@kennethpaige7036 2 жыл бұрын

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!

@eticollege7870 5 жыл бұрын

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

@Monica-hz9dk 6 жыл бұрын

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!

@hectoralicea3079 2 жыл бұрын

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. 👍😊💖

@luisedy2519 3 жыл бұрын

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.

@jayrhoads9741 2 жыл бұрын

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.

@weblady14 5 жыл бұрын

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!

@LeilaGharani 5 жыл бұрын

You're very welcome. For this exact reason, I also watch videos I think I know the content of... you never know what you discover :)

@tamariwatkins4454 Жыл бұрын

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

@HubertKirchgaessner 5 жыл бұрын

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!

@freefirek-series6487 3 жыл бұрын

kzfaq.info/love/tNr753qbiVw61oY_ow_aPw New channel need your valuable support 🙏❣️😇😍

@mariealvarez7652 5 жыл бұрын

I love your video's they are very helpful. I'm going to try to use this for during payroll in my company.

@isaacmwabila5830 2 жыл бұрын

Your videos are interesting, thank you for always adding something new in our Excel knowledge! 👌🏽👏

@2012worship Жыл бұрын

I love all your video tutorials. Always learning something new even on the topics I already know. Thank you so much!

@saidaselhaoui4174 5 жыл бұрын

Thank you for the nice refresher Mrs Leila Gharani!

@benjaminapete 3 ай бұрын

Thank you! I've watched 5 other videos on this and this was the best explanation.

@user-cz8yx7lq1e 5 ай бұрын

Sensational, Leila! It helped a lot! I needed exactly the solution at minute 5:44 (Using Table References). Congratulations on the excellent video! And thank you very much!

@swagisonpoint Жыл бұрын

Wow. This is the second video I have watched. I thought I was a master but you definitely taught me a lot. Still looking for a certain answer so I will look through your videos to see if you addressed it. Thank you Leila!

@wangt618 3 жыл бұрын

Hi Leila, I'm loving your videos as I've been setting aside time to upgrade my Excel skills. At 13:25 of this video, you mentioned to drop a note if we are looking to learn how to use the custom function and the corresponding formula for the "Company code." Can you direct me to the video or the instructions for this? Thank you!

@martinabuya8982 7 ай бұрын

Thanks Leila. I've gained a lot of insights from lecture on data validation on audit findings relevant departments.

@johnq3543 5 жыл бұрын

Thanks so much Leila. Your vid's are great, I'm learning so much from you !!

@emrulhasan1705 2 жыл бұрын

Leila you are one of the best Excel teacher in KZfaq.

@krishnaprakash3422 2 жыл бұрын

Mam- Thank you for your data-validation video - plz continue to maintain , the same audio/video-delivery, its just superb to understand you!

@euniceesinam2573 3 жыл бұрын

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.

@LeilaGharani 3 жыл бұрын

Glad you were able to pick up something new, Eunice :)

@zahirzoy9492 Жыл бұрын

Hi Leila I have Joined an organization where I Do face lots of such problem where I don't have any experience in validation and so on but watching your videos I have just solved all these problems because of the clarity you have in explaining.

@clarence8639 2 жыл бұрын

Very informative content and I especially like the way you deliver it! Thank you, Leila!

@clarence8639 2 жыл бұрын

Congratulations on 1M by the way!

@michaelyambasu5254 Жыл бұрын

Hi Leila, I am really enjoying your Excel classes. I will like to see how programming in the custom function works. Thank you. A big fan from Sierra Leone, West Africa. BR.😊

@davidkeck6183 8 ай бұрын

This is EXACTLY what I needed to know. There's a reason why you have. 2.38 million subscribers and counting. Thank you and Bravo!

@sachinrv1 6 жыл бұрын

Hi Leila, It's always wonderful to watch your videos. And as you rightly said; it's really useful when the spreadsheet is going to be used by many users. Using data validation, one can easily take care of the obvious mistakes that users could make. Lovely.

@LeilaGharani 6 жыл бұрын

Thank you Sachin for dropping by :)

@purbitajannat 2 жыл бұрын

Hi Leila, thanks for all your effort. It worths watching your excel tutorials. Please share such tutorials on word and ppt. No one made a good video worth watching yet. Hope you can do.

@bluejeans706 4 жыл бұрын

Thank you for your video! Even on functionality I know, you always teach me something new about it :) And yes, I would love to see a video on using the custom formula option to validate the user's entry is within the prescribed syntax.

@sealttas 4 жыл бұрын

Your whole videos are like excel for dummies. I understand every step of what you are doing. They are all so easy when someone explains it clearly. Perfect! Thanks.

@LeilaGharani 4 жыл бұрын

I'm glad the tutorials come across as easy to follow. Thanks for the kind feedback.

@moo-tee7755 3 жыл бұрын

Hello Leila, thank you for the video + other videos as I’m busy upgrading my excel knowledge. I was recently ask to create overtime sheet for all the employees so that account can cost and I didn’t want to type the names and the divisions every time and drop down will be ideal for this exercise

@hossamabdelghafar1613 4 жыл бұрын

I love these explanations Leila, you have mastered on what you do

@freefirek-series6487 3 жыл бұрын

kzfaq.info/love/tNr753qbiVw61oY_ow_aPw New channel need your valuable support 🙏❣️😇😍

@mark91345 5 жыл бұрын

I love these explanations. I just follow each step and it works.

@jimbarton7072 4 жыл бұрын

Another wonderful video, Leila. I use validation for dropdowns all the time, using the Indirect/table method. I teach Excel in a US public library and recommend your channel and Udemy courses to all my students.

@LeilaGharani 4 жыл бұрын

Wow, thanks for your support James!

@DFDFusion1 4 жыл бұрын

Don't know where i'd be without these videos! Super easy to understand THANK YOU!!

@LeilaGharani 4 жыл бұрын

My pleasure Joseph. Glad to help.

@gulusankara8922 4 жыл бұрын

Thank you much for all the help. Your videos are very clear and easy to follow.

@PaulVass1 6 жыл бұрын

Another informative video Leila👏 Well done! I love the validation tools and thought I new all the tricks. Your video showed me more. At work my job is to prepare reports from the data so validation ensures the data is clean.

@LeilaGharani 6 жыл бұрын

Agree - validations help catch the bigger errors. I'm glad you found something new in this video. Thank you for your support.

@colibrireader 3 жыл бұрын

You are still my number one source for Excel queries. You never let me down. Thank you!

@LeilaGharani 3 жыл бұрын

Great to hear, Leo!

@bluedevil006 6 ай бұрын

WOW...I spent days trying to figure out a complex drop down list that would fill multiple columns all at once...had most of it figured but couldn't quite get it right...5 minutes of your video and it's done!! THANK YOU! Table reference on another worksheet was the key!

@LeilaGharani 6 ай бұрын

Glad it helped!

@aureliohess9349 Жыл бұрын

Good work, dear Leila. Thank you, and Congrats!!!

@TheRolypolie Жыл бұрын

Hi Leila is my first day, and is a pleasure to learn from you and clear explanation Thank you

@kuldipaggarwal7288 6 жыл бұрын

Thanks Leila. Just started watching your Videos and find them very informative. |Also signed up to your course on VBA. This is definitely helping with improving my knowledge.

@LeilaGharani 6 жыл бұрын

I'm glad to hear you find the videos useful! Thank you for your support of my courses. I hope you find lots of value in the VBA course.

@stevegrayson3719 4 жыл бұрын

Just stumbled across your tutorials on Excel, fantastic and really well presented.Well don, Ive bookmarked these.

@LeilaGharani 4 жыл бұрын

Glad you like them Steve!

@gillesfournier9457 3 жыл бұрын

Well explained, good speed, clear and using proper terms. The way you approach it by bringing the rational behind make it easy and better memorizable.

@LeilaGharani 3 жыл бұрын

Glad you like the tutorial, Gilles.

@bulentesin9658 4 жыл бұрын

Love your art of explanations and last but not least; not every Excel master is a teacher...

@TruthHertz642 2 жыл бұрын

So helpful (and timely)! God bless you.

@thewisdom6668 2 жыл бұрын

The video is clear and makes things easy ! thank you so much 🙏

@mirrorballd 2 жыл бұрын

Thank you! Thorough explanation and very helpful. 👏

@Flow_with_G 3 жыл бұрын

Thank you for your videos. Always so informative. In regards to data validation, I just selected the column in the source and whatever I add later in that column will appear automatically.

@valentinekofiadu9928 Жыл бұрын

Am generating a template for estimates which consists of plant, labor and materials. So I use data validation for PLM and then "lookup" to generate the appreciate rates. I used the name manager privously but thanks to this vid, I can switch to tables which will automate all my changes. Great content.

@amiraboodi2075 2 жыл бұрын

Helpful and interesting. Your explanasion is very clear. Thanks a lot.

@susank6122 Жыл бұрын

For two days now I've been looking for a way to use table data as the dynamic reference when using a list in the data validation. NOW I know how to do it using the Indirect -- go to 7:19 in video. THANK YOU.

@ibrahimsaeed237 2 жыл бұрын

Leila you make me love EXCEL day after day I never tired of learning with you here and in udemy .although I am not good in English but I get what you say and what you explain

@harishpaldhir5915 6 жыл бұрын

Very very good and increasing my basic knowledge about validations

@abdulrahmanmuslih141 Жыл бұрын

thanks a lot. you are one of the best Excel expert in my opinion .

@hannieo4598 4 жыл бұрын

Leila, thank you for your videos. They are very helpful and easy to understand.

@LeilaGharani 4 жыл бұрын

You're most welcome Hannie. I'm glad the tutorials are helpful.

@Maria-bo6ug 5 жыл бұрын

So greatful to have bumped into her KZfaq channel. Hope to see more 😊. Thank you ❤️

@LeilaGharani 5 жыл бұрын

I'm glad you found us :)

@dasrotrad 6 жыл бұрын

I had been using Conditional formatting to highlight specific data in my columns. I now have more tools to work with... Great video. Thank you!!!

@LeilaGharani 6 жыл бұрын

Glad you like the video :)

@mostafahassan5021 5 жыл бұрын

Wow, you are such a brilliant expert

@GameAGuy Жыл бұрын

I love your content. You are teaching me everything. Thank you so much

@meaf 3 жыл бұрын

You are so amazing! Please don't stop! Keep these videos coming.

@MrZamuhammed 5 жыл бұрын

Thanks a lot Leila. Your lecture is great and really intersting....., I'm thinking I'm little bit late to know about you. Wish you all the best.

@tazeemn 3 жыл бұрын

Very nice video. Such calm was of presenting. Well done.

@charisc8437 3 жыл бұрын

Thank you. You have explained so clear.

@kwenahlako2987 6 жыл бұрын

I have the best excel tutor by far. I am looking forward to learning a lot of Excel from you this year:) Thanks a mil

@LeilaGharani 6 жыл бұрын

I'm glad to hear that! Lots of Excel stuff coming your way this year :)

@adelahmed-fb6gv 4 жыл бұрын

Leila, Really appreciate what you are doing and keep going as if I don`t know anything , Just I prefer your channel to get what I need Many Thanks, You mentioned that according to " I need the video according to company code starting with letter beside numbers )) and Thank you in advance

@johng5295 3 жыл бұрын

Thanks in a million Robert. What an inventive mind. A++

@khaledxerox Жыл бұрын

You are amazing at teaching :) thanks I will start the data validation for my maintenance reports team

@yamilandres 5 жыл бұрын

Very educational.. and pleasant to watch. Thank you, dear Leila!

@LeilaGharani 5 жыл бұрын

You're very welcome. Glad you like it.

@ruslanalikhanov1416 4 жыл бұрын

Это то что я хотел знать об этой фунции. Коротко и по делу. Огромное спасибо Вам. С Уважением.

@LeilaGharani 4 жыл бұрын

My pleasure. Glad to help.

@J_T_1 3 жыл бұрын

Great content, concise and to the point!!

@ashishawale54 4 жыл бұрын

You explains me very well. I understand all time.

@constanceenon6289 3 жыл бұрын

This video just made my day. Thank You Leila!

@LeilaGharani 3 жыл бұрын

You're so welcome!

@WiliamBennettwildarbennett 4 жыл бұрын

I do an annual Fire Department Fire Board report and have to input the mileage logged for each Fire call for the Firefighters. So in past I have had to manually look up the individual FF's response as well as to log what type of call that it was. So this will help in having the addresses in a Validation list as well as the Response times as well as the mileage. Thank you for very clear instructions in all of your training.

@LeilaGharani 4 жыл бұрын

That's great. I'm glad it's helpful for your report.

@gurdevgurdial5753 4 жыл бұрын

excellent..its very useful and easy to follow! thanks

@nomoreospf 2 жыл бұрын

Excellent, thank you! Very informative.

@dgsmli8055 5 жыл бұрын

You are the best!!! love your videos, you are making my life so much easier !!!! keep posting please .

@LeilaGharani 5 жыл бұрын

I'm very happy to hear that. Definitely, more videos will come your way :)

@mehdihammadi6145 4 жыл бұрын

The video is amazing but what I really appreciate is the trick to use columns names in the validation. Thank you Leila for sharing

@LeilaGharani 4 жыл бұрын

My pleasure Mehdi. Glad you find it useful.

@thomasnewton8357 Жыл бұрын

Hi Leila, you're fantastic teacher, thank you very much indeed! Was just wondering is there anywhere I could ask a quick question about summing something in excel? Thanks

@ismailismaili0071 6 жыл бұрын

Thanks Ms. Leila i really was looking for this video to know more about data validation

@LeilaGharani 6 жыл бұрын

Thanks Ismail - I'm glad you found it :)

@MrMumumumu 2 жыл бұрын

I was looking for an hour now to the solution with the indirect-function you show at 6:50 - thank you so much! I was getting so mad... This doesn't seem to be a problem in other tutorials I saw, it always worked without it so the content creator didn't (have to) show this function.

@narendratayade8992 5 жыл бұрын

Thank you Leila mam very useful video it's improve confidence & interest in work. Awesome

@csamson01 Жыл бұрын

Your Videos are so good you do A GREAT JOB! thanks you.

@yulinliu850 6 жыл бұрын

Another great short lecture. Thanks!

@hasanrizvi3743 4 жыл бұрын

Quite informative. Thanks MAM

@yaashjut76 5 жыл бұрын

Dear Leila, this lesson added value, as before watch this video i was aware of basic use of data validation. Thank you

@LeilaGharani 5 жыл бұрын

You're welcome Yasir. I'm glad you found some useful tips here.

@shayneh8668 2 жыл бұрын

Love your content, thank you for all of these tips.

@abdullaalbabul1250 Жыл бұрын

Thank you. After see your video, I have solve my problem. Best of luck!

@dadmezz4024 4 жыл бұрын

Great job Leila. A lot of time I make lists, this input data using drop downs will be helpful. How could I input always at the top line so all the data will scroll down in the order that it was listed?

@thedinokid1501 5 жыл бұрын

Hi mam am a big fan of ur teachings!!! We can also add to the table without naming the table in the source without using indirect formula, I think we can skip this step as it automatically takes the new rows added!!!