🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
@guytaylor84962 жыл бұрын
How can I create drop down for choosing a date?
@KevinStratvert2 жыл бұрын
@@guytaylor8496 unfortunately you can't do it out of the box. There are third party plug ins that give you that capability.
@ErisvaldoJunior9 ай бұрын
Didn't work automatic input for new value
@mdfenn Жыл бұрын
Basically my boss thinks I’m like really talented. Nope I just pull up these videos ever time I need to do something new in excel. Thanks man!
@veronica9896 Жыл бұрын
Same here. 😊 Kevin, you are a real life/work saver 💯♥️
@marnonjaetolentino1825 Жыл бұрын
thats why im here
@Hjonvard9 ай бұрын
Great tutorial. No fluff, no annoying music, crystal clear speaking. You need to make a tutorial on making tutorials
@barryeady22393 жыл бұрын
Great job explaining the drop down list. How can you use the drop down list to bring in additional columns from the list. Example: The drop down list contain various fruits. When you select a fruit, the related unit price of that fruit also populates the table. Then, you can enter the quantity and use a formula to get the extended price. Similar to an invoice.
@wangag26633 жыл бұрын
Honestly i thought it was more complicated than this!!! I've always avoided working with excel (or doing stuff manually with no formulas etc) coz some instructions or videos are so vague or poorly made respectively. Ill be checking out later "pivot tables" if you have a video on that. I am sooo subcribing to learn more tricks. PS: This is the longest comment i've ever made on YT.
@chidubemnnabugwu26252 жыл бұрын
😅
@thecatlady-n3n7 ай бұрын
It's taken me a while but I got there in the end. You have to be careful to do the steps in order otherwise it all goes pear shaped. I do believe I've learned a new skill. Thanks Kevin.
@Thrive2024 Жыл бұрын
Thank you so much sir Kevin, actually my teacher assigned us an assignment regarding this kind of scenario where we are needed to think a solution on how can we immediately have a list of items so we can easily input it on a cell. Fortunately I have found this video of you, You save me😢😊❤🎉 Thank you so much once again.🎉
@gillianyao69762 жыл бұрын
Very clear and concise, applied to my worksheet immediately! Thanks
@bettyc931 Жыл бұрын
I have been trying to find this by reading or other videos online. You gave the clearest explanation. Thank you!!
@adolor6570 Жыл бұрын
Thanks Kevin. I like how you get straight to the point. No long winded videos.
@jasonchristopherson52436 ай бұрын
Excellent Tutorial Kevin, saved me a lot of time and headaches! The only issue that I am having is when I add additional content to the tables they are not showing in the drop downs even though they are showing as part of the table, the data validation is limiting to my original table. I am and absolute novice so if anyone reads this and knows what I am doing wrong I would greatly appreciate a hand!
@RemRaye3 жыл бұрын
I'm taking a Microsoft Office class for a degree, and couldn't figure out how to create survey in Excel 365 until I found this video. Thanks so much for breaking it down into easy to repeat parts!
@foxfields3 ай бұрын
THANK YOU! I love the extra features where you can write instructions. I was able to sass my boss about messing up the values in my table :)
@Discretion_seems_to_be_fading. Жыл бұрын
I suuuper appreciate when I need an answer and I get EXACTLY what I needed without all the fluff. So much so, that I'm actually leaving this comment and thumbs upping your vid. Thanks.
@renaldimrp9425 Жыл бұрын
Awesome!. I always look forward to your uploads, they're consistently great. Thanks for the detailed and honest review, it helped me make a better decision..
@IlluminatingThoughtTv Жыл бұрын
This tutorial is awesome! I learned more from this tutorial than I did in a semester in college! Excellent Video!
@growqueen3 жыл бұрын
OMG you are the best. This is exactly what I needed. My boss asked me to do this and I had no idea.
@Gan83259 ай бұрын
You are so clear and easy to explain things. Thank you for your patience.
@maulanachafid Жыл бұрын
Helpful information. I can tell that a lot of thought went into the making of this video.. The last one hit me really hard.
@TheRandyGr6 ай бұрын
Thanks for sharing Kevin. Always great to find out these little things that can really take a project to the next level!
@carlabryant35504 жыл бұрын
Thank you for these wonderful "how to" videos! Questions re: drop down list: 1.) Can you create a dropdown list in Excel and copy and paste it into Word? will it function? How do you get it to function? 2.) How do you put a blank "value" in your drop down list? Feel free to simply point me in the direction of another video if you have already answered this. Thanks so much for your help.
@dreudax32942 жыл бұрын
Its been long time, but can you do this? Also if it is possible it would be of great help if you can mention some keywords to research into thsi. Thanks.
@sherellebuk6 ай бұрын
Thank you, your videos are amazing! Always explained in a clear and simple way that is easy to understand.
@nathanpiper13462 ай бұрын
quick and to the point, ty mate
@user-ht6rj9fm3k Жыл бұрын
Great article to refresh knowledge, I almost forgot this when I stop working. Thanks
@spartanadam3935 Жыл бұрын
Fantastic tutorial, however, mines is not updating dynamically. I do have my list as a table with header in a separate sheet, but it won’t update if I add data to the table.
@frankdewit344510 ай бұрын
Do u got a awnser already? I got the same problem. cheers
@spartanadam39359 ай бұрын
@@frankdewit3445 Yes, you’ll create that list as a table (ctrl + T). Give table a meaningful name. Now in data validation use =INDIRECT("CategoryList") where categorylist is your table name. Hope this helps.
@oluwaseyiosagie9333 Жыл бұрын
Thank you, your illustration was absolutely on point and has just made my life easier.
@r2sweeth4 жыл бұрын
You made it look simple!! Thank you for not over explaining
@samuelopoku-agyeman94329 ай бұрын
Good tutorials, Kindly add how the drop down can generate a report straight away.
@dylalokman10 ай бұрын
Thank you! Very easy to understand and manage to create my own drop-down list in excel!
@michaelgalik16303 жыл бұрын
Thank you, it clear even for me who has very limited knowledge of Excel
@jennajones93993 жыл бұрын
Ditto!
@henrykoge831010 ай бұрын
You are awesome Kevin, I have learnt so much from your channel. Thanks for sharing your knowledge
@christinapantouli4783 Жыл бұрын
Thanks Kevin.I have learnt a lot just watching your videos 😊
@dintang2476 Жыл бұрын
Entertaining!. I really enjoy watching your videos, I can't wait for the next one!. The last one hit me really hard.
@MR-ul6bc7 ай бұрын
My teammate just quit and I needed to know how to do this. Thanks for posting.
@harshenvy7 ай бұрын
It first didn’t workout for me until I realised that some excel versions require a semicolon (;) instead of a comma (,) when writing 3:15. It’s a small difference that had me buzzing for like 5 minutes. Hope others avoid this mistake
@Cathoray201211 ай бұрын
Excellent tutorial for using drop down lists. I liked the extras at the end of the video - will have to make use of that.
@_keziaroberts3 ай бұрын
Your videos are super helpful! Recommending your channel to my friends right away!
@oliviaakinyi10683 жыл бұрын
Excel is now made easier, Thanks Kevin
@ratgirl6692 жыл бұрын
The input message and error message was SO useful! Thanks dude
@michaelhulle86094 жыл бұрын
Why are you always the best? Another great one.
@lauracriado37979 ай бұрын
Now I understand this drop down list... Thank you!
@user-zm3eo6gn8h11 ай бұрын
Great video Kevin, I keep forgetting how to do this, as its only done occasionally! Thanks for creating the video!
@FilmBookReview Жыл бұрын
Thank you. Helpful. Just used it to create my first drop down menu.
@lorrainebingham726 Жыл бұрын
Oh and by the way, great explanation. I used it for my first try of course there was an item that needed to be added to the list and the user did not know what to do.
@arthurkklam3 жыл бұрын
Thank you Kevin. You make life much easier!
@angelagarza2150 Жыл бұрын
This was so helpful!! I thought it would be difficult to create. You just helped me on how to create schedule for work . I have been manually typing in information.
@pattyfrick53753 жыл бұрын
You videos are awesome...the best I have found so far. Thank you.
@abdurahman99410 ай бұрын
Thanks brother. Really helpful videos. May almighty bless you.
@elizabethlee45733 жыл бұрын
I love your you tube videos. Keep up the good work! They are helpful, useful and best of all , it is easy to follow.
@crisstones723 жыл бұрын
You are the best! Thanks ! Anyway you could please show us how to create “consequential (dependent) drop down lists”? Thanks!
@osPA7810 ай бұрын
Quick, simple, and straight to the point! Thank you so much for this video!
@TetsusaigaDrgn2 жыл бұрын
Thanks kevin...this was helpful and easy to grasp with the way you explained it!
@RazgrizRevenge Жыл бұрын
dude this really saved my but today thanks for the help
@bncprado Жыл бұрын
Hi. Man, you help so many people with your tutorials. Thank you very much. When I create a table and tell the dropdown menu to get info from the table, it doesn't update automatically when I add new items to the table. Am I doing anything wrong? thank you
@misterpogiako3 жыл бұрын
it begins to really start and commence at around 2:31. surely that's what you came here for
@rosalesfamily218510 ай бұрын
Love your videos, all of them are extremely helpful. This is going to make my job easier!!
@diytwoincollege70793 ай бұрын
Thanks. This made it easy!
@Aarontlondon Жыл бұрын
Thanks for explaining it clearly!
@megancantley2949 Жыл бұрын
Genius, I feel like one too 💡👏🏼thank you for this clear explanation 😊
@hninaye80544 жыл бұрын
Thank you. It is so easy to follow and short to the point! Thumbs up!!
@posentien3283 Жыл бұрын
This is amazing, thanks Kevin for you sharing!
@user-be8ky4un6oАй бұрын
that was great - I want to see how to change/apply the color palette, based on date range, in a calendar Gantt chart. I used a template, and made changes, but cells don't show the formats I can replicate.
@Muzala_-ny7ri5 ай бұрын
Very helpful video... 🥰thank you so much
@vickydejager4238 Жыл бұрын
You a genius! Thank you so much, easy peasy.
@iRaskulz Жыл бұрын
Liked and Subscribed! this video was awesome, thanks!
@feyzanuronal25983 ай бұрын
Super helpful! Thanks a lot for the great tips!
@akunnaafolabi3885 Жыл бұрын
Thanks Kevin, this is very helpful
@Monika-nb6ur3 жыл бұрын
Literally binge watching all your videos, thank you so much for the content! :)
@tanvigawde1612 Жыл бұрын
Wow!! This was super helpful!! Thank you!!
@witchhazel2 Жыл бұрын
Very clear explanation. Thank you so much! ❤
@santtumakinen8109 Жыл бұрын
Worked! Thank You!
@nathanwanda48294 жыл бұрын
Thanks for the explanation. I want to be show how to make a dropdown box from a dropped down box and repeated many times. I want to use this for family tree starting with grand papa up to future great grand children. Thank you.
@dr.stalins28766 ай бұрын
Excellent Mr. Kevin
@tumbalsatu-vy7uw Жыл бұрын
Incredible!. Thanks for the clear and concise instructions, they were very helpful. Thanks for your review, it helped me make a more informed decision..
@yanniesoo80822 жыл бұрын
thank you Kevin! This video is very clear!
@abdikadirhillow98758 ай бұрын
very educative,it has really helped.Thanks
@IvanGarcia-cx5jm Жыл бұрын
Thanks! This helped.
@AnaLauraIreta-vk4kh Жыл бұрын
Love the great explanation!
@tliani149410 ай бұрын
Thank you so much for your sharing..
@kickingitwithmisha11 ай бұрын
Yessss this made my job way easier ❤❤❤
@primenanip93053 жыл бұрын
thank you kevin!
@SotyPaige Жыл бұрын
As always, you make it clear and easy to follow. Thank you Kevin.
@MOMODEST Жыл бұрын
Excellent, thank you!
@priyanthalamuthu7401 Жыл бұрын
Neat, thanks Kevin!
@burhanhantu1714 Жыл бұрын
Nice video man. This video is so well-researched and well-presented. Hey man put something new on your video.
@sazalimohamedsalleh39708 ай бұрын
Thanks Kevin
@noorkhawaja Жыл бұрын
Very helpful video. Thank you.
@amiodynski2 ай бұрын
Thanks for the great video. How do I take my list from the drop downs, and let say add each drop down ie; bakery, produce, meet to see how many of each I have?
@aldotrillo4642 Жыл бұрын
Hello, Congratulations, your videos are the best! Please help me with this... How can I include a "Select all" option in a drop down list?, because once an option is selected I can't look all the options again.
@jimmylittleuk2 жыл бұрын
thanks for this, now i know!
@natashiawilliams322 жыл бұрын
Hi Kevin- How can you use the drop-down list and select multiple selections with a comma and a new line? Can you please cover the VisualBasic process please?
@user-og5ct3kb3p Жыл бұрын
Thank you! Great tutorial!
@justahedonist38592 жыл бұрын
Excellent tutorial! Straight to the point
@godfreytshimauswu48463 жыл бұрын
Great presentation. impressed.Keep it up.Godfrey Tshimauswu , South Africa
@dianaavalos30335 ай бұрын
Thank you! I *really* needed the reminder!
@sagi6629 ай бұрын
Great tutorial! Thank you. I'd rather watch your videos then the Excel tutorials on the Home page 🙂. I really like how to add the messages - never knew how to do that. One question I have is: on the data validation box, settings tab, there are two boxes that are checked by default - what are those about? Should "ignore blank" be left check? Does that mean someone could just ignore the cell and not make a selection?