Advanced Excel - Data Validation and Drop-Down Lists
Vložit
- čas přidán 1. 10. 2017
- Learn how to use Data Validation tools in Excel to improve the accuracy of the data in your spreadsheets. One of the Data Validation features you'll learn in this video is how to create Excel drop-down lists so that the person entering data can simply click a button and choose from a list of possible entries. ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... My entire playlist of Excel tutorials: bit.ly/tech4excel
Movies Mentioned in this Video:
Dirty Rotten Scoundrels: amzn.to/2xTpck1
The Princess Bride: amzn.to/2yk3tDc
Ladyhawke: amzn.to/2xOhLsA
Stardust: amzn.to/2yjJvs9
Young Sherlock Holmes: amzn.to/2xaJJNv
Mystery Men: amzn.to/2yRmQ3r
Music Mentioned in this Video:
Classic Synthpop and New Wave:
Depeche Mode - Violator: amzn.to/2utJMqp
Alphaville - Forever Young: amzn.to/2tl4gle
OMD - Messages: The Best of OMD: amzn.to/2uyz1Ct
New Music by Classic Synthpop Bands:
A-ha - Foot of the Mountain: amzn.to/2tbfrsv
Alphaville - Catching Rays on Giant: amzn.to/2tbD445
Underground Modern Synthpop:
Code 64 - Departure: amzn.to/2tbEtbd
Echo Image - Compuphonic: amzn.to/2uEvzr4 - Jak na to + styl
I used to think creating such things as the drop downs were really advanced techniques, but you've shown how easy it is for even a beginner. Thank you for your videos.
For the individuals who are taking the Microsoft Office ProveIt Assessment (Outlook, Word, Excel, and PowerPoint), I highly encourage this video. I passed my tests with an overall score of 90.75. I made sure to add the video to my favorites so that if I am lacking in an area in the future, I can refer back to this video. Clear and concise instructions. The individual teaching this video is a great communicator in the sense that he does not bombard the viewers with confusing information.
This tutorial is AMAZING. Your way of explaining things is so clear and methodical and it is a pleasure to listen to you talk. I find your explanations so easy to follow. Have just learned this amazing data validation but only because you made it so very easy. Phenomenal. Once I have a bit more time I am going to look into your tutorials in more detail. For the time being, and to stop my team messing up the spreadsheet we work from by putting whatever they please in each cell, I needed desperately to learn how to do the dropdown lists to restrict their choices. So very grateful to you. Thank you
You have changed my life with your Excel videos. I feel that Excel is the hardest to understand conceptually at first, but with practice, other Microsoft programs make sense. Please never take these videos down. Thank you sir.
All your videos are so well explained. Thanks for the great learning resource.
This is so clear and well explained. I feel like you opened a world in front of me! Thank you for this video.
all your videos are great teaching devices many thanks!
czcams.com/video/alV9Dn7YIfA/video.html
This man's love of synthpop is legendary
Had totally forgotten how to use Excel. Doing a Master's degree and need to do a research log in Excel. Came upon your videos...you are a star!! It has all come back to me, thank you so much!!! You explain everything so well and clearly...and love the sense of humour!
I too am in my masters program and find myself lost with excel!! these are very helpful
I absolutely love your videos. Excel is now fun and easy for me. I did a list of tv shows I'm watching, what seasons I'm missing, etc, lol, so it's been kind of similar and allowed me to practice. Just by watching the beginners, intermediate and now the advanced ones I went on to explore other functions, just figured how to do the genre's list throughout different sheets, etc... amazing!
which shows you watching?
excel is great for personal use just as it is for professional work, especially goal tracking
OMG, I Absolutely Love your website; I feel as though I am Back in School and listening to everything also watching it actually happen.
Thank you.. My Professor of MABS recommended for watching you lessons of word and exel then ppt.. you made it easy for me.. thank you شكرا
When you use data validation, source....you can just type the first letter and it will pop up ;) Love your videos!
Your continued commentary on synthpop cracked me up. Great vid.
I got my Excel certification back in 2015 through my university, but didn't really get to use excel afterwards. I'm so glad i found this channel, i've been dying to refresh my memory on some of the important advanced functions that I had forgotten!
Wow, this video is amazing. You explain everything clearly and concisely. I was truly afraid of excel, now I have been using it like crazy at work and making personal forms for my vast comic and music collections. You are a God- Send! Thank you, thank you!!!!
I enjoy hearing you speak. You sound so clear, articulate and pleasant. Definitely makes the learning experience rewarding. Thanks for uploading all the videos that you have :-)
I am taking an Excel basic course in the company I work for. I didn't understand this topic at all. After watching your tutorial I am a lot more clear. Thank you very much. I have to say that the way you explain makes it also easier. Congratulations and blessings!
I am amazed to see that a so clear explanation can be done and also in such an elegant way!
I have NEVER commented on vids, until today. THANK YOU! You have excellent teaching skills.
Your explanations are the best I've ever heard! Have tried many times to learn vlookup and pivot tables without success. BUT your voice, style, and explanations have helped me better than I ever thought I could learn! Thank you so much!!
Nice movie collection, love older movies as well as older music. Great job thank you.
Short and to the point, awesome. Great class, thank you!
For someone who did not know much going into it, these videos have certainly helped me out a lot.
Watched the main three tutorials and honestly I wanna take this time to appreciate that you made them because it truly will help me a lot.
I start my first ever office job tomorrow, wish me luck☀️
Best tutorial, clear voice, well structured. very well done and THANK YOU.
I am very grateful. All your videos i have watched has been of great help to me.
Much appreciated.
God bless you
I’d love to see some Statistics videos. You do a great job explaining thoroughly.
New to ANY sort of technology! Your explanations using Excel are at a level I can actually follow and apply...Thank you!
Your excel tutorials are best, concise, organized well, easy to understand, and love the music!
These tutorials are very helpful and I appreciate your sense of humor (re: romance movies) along the way.
You deserve the world for creating these videos.
Your videos make (re)learning Excel effective through simplicity and compelling style. TY!
Learning this is like cavemen discovering fire.
you're a hero. I'm binging your excel videos so that I can start sorting my steaming pile of overwhelming work tomorrow 😵
Beautiful tutorial! Loved the series.
I find these videos to be extremely helpful particularly when you follow the important one in sequential orders. Then, I look at other videos for extra knowledge. Thank you very much.
Many many thanks! Your way of teaching - combined with your calm voice - is wonderful!
Thank you so much! I needed a refresh for a new position I applied too and your videos were the best!
Thank you for great videos! And thank you for making them awesome with your little personal touches (like DEPECHE MODE)! ;) I'm a happy student! lol! :)
I love your training videos! Very helpful!
I am beginner in learning Computer Programmes, your all Videos are great to start and endup by learning clearly, Its such a great platform and you are the best Teacher with Excellent Articulation.
Wow! Your explanations are very clear and precise. As a non-english speaker, I understand everything very well. I'm starting to apply for my very first job soon and I find your tutorials very helpful and useful. Thankyou so much! All credits to you brother. Thanks for sharing your knowledge with us. God bless you.
Lol. Best part is new wave “will always be relevant”. Haha great vids man.
Bro 😂😂
@Conner Roberts What the hell man
cant stress enough what good teacher you are!!!! thank you
You speak very clearly with the right rhythm. So you made your videos very easy to follow. I learned a lot from them. They helped me to get started with my new job. Thank you very much.
You are a great teacher indeed. Love your lectures.
I must confess you are indeed great in your ways of teaching, thanks so much and more Grace as you keep helping people 👏👏😊
Thank you!! Needed to brush up on my Excel skills. Your videos are the best.
I was looking for a teacher on advanced excel and I did not what to do as I got no time to go far.But now looking these videos has made me great
Thanks
Great tutorials! Please keep them coming... they are very helpful!
Thank you so much for all your excel videos! I wish you well, you're such a kind person.
Best instruction!! Very helpful ! Thank you.
Great Tutorials. To the point and well explained. Thank you!
Your tutorial videos are easy and simple to understand. Thanks.
Thank you for sharing, it a great lesson.
So good. I’m learning both excel skills and movies. I love how u categorized movies by locations. So funny!!
I absolutely love your videos on Excel! They are so useful and so helpful. Id like to test my knowledge? Do you have any tests?
I really appreciate you taking the time to teach!!! God bless you and blessings to you sir!!! I am trying to get a job in a medical setting, patient intake, billing. Can you think of anymore programs that would be helpful to know?
Thanks for those videos, much appreciated.
You were born to teach :) Thanks for the videos!
I've been going video to video trying to understand but your channel is the one that really did it. Thank you sir.
Thank you. Thank you and thank you. You saved a soul. I have learned so much in very little time. Well explained, precise and clear to the point. Well done man
thank you! it's 2019 and my clients will now love me even more
Man your videos are great. You do a great job. Thank you very much for all the teaching and clear information that you put on your videos. Much appreciated.
Amazing explanation. It covered everything the topic encircles.
Thank you ! Its very clear, I like the way you present it.
Very helpful tutorial. Thanks!
It may be worth pointing that list will work regardless of where it is put. Great videos.
They way you teach this is so fun, I’m so happy I found a teacher that teaches tech in such a cool way, unlike my teachers
Love your videos!
Thank you so much for this. I took the same computer class in college twice because I failed the first time. We had labs but they never taught us excel. TheY taught us Word and a little Powerpoint. I had a project on excel. Imagine how it went the first time. The second time I ask a friend who knows excel to do this for me and then show me how did he do it. I paid 1.000 euros twice to learn Powerpoint (something I learned by myself. Not an expert but I felt it was a waste of time.) 4 month and didn't learn what I needed to. So thank you so much for this.
Thank you! Your videos are really helpful.
Great tutorial, clear and compelling. thank you!
you are such a good teacher. i love every lesson. well articulated
thank you do much, these tutorials helped me alot, you truly are the best excel teacher on youtube !
Super helpful video. Thank you!
Great videos. You threw some good jokes in there too
God Almighty bless you bro. I love your videos and I already feel like a Professional in Excel right now. Keep it up bro
Wow, I am literally amazed. great video
Great tuts and fabulous sense of humor!
I like how you pronounce 'Ok'. Thanks for the great videos.
Thank you for the tutorial. Truly appreciate it!
Simple, clear, and to the point Thank you thank you 🙏☺️ you are superb
Very helpful. I had figured it out but your video validated that I did it correctly. Thanks.
Thank you o much for the videos! It is helping tremendously in my new position!
Love this! First time learning about this
Had to catch up with my high school daughter's proficiency ... your navigational / application videos have been great!!
THANK YOU for the BESTplayslist of excel in all of youtube ! thaaank uuuu
Thank you so much for your videos, they are really helpful...
I'm new on Excel, no experience here ,now I'm learning something new, thanks
I am a first time user and i love your videos, so easy to understand, thank you!
Such a nice diction and comprehensible speech. Thank you very much for your videos.
a very educating piece , i always enjoy using it to improve myself. i am very grateful.
Excellent tutorial - explained everything I need to get started👍
thank you for your videos. i really like how you explain everything plain and simple for us to understand.
Thanks, Merry Christmas🎄 and Happy New Year
Thanks for your help and public service.
Great info. Please provide more videos. Keep up the great work again.
thankk you for the videos ! I really love them and it makes learning easy