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
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.
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.
This man's love of synthpop is legendary
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
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
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.
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 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
You deserve the world for creating these videos.
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
OMG, I Absolutely Love your website; I feel as though I am Back in School and listening to everything also watching it actually happen.
Learning this is like cavemen discovering fire.
Your continued commentary on synthpop cracked me up. Great vid.
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!!!!
Your excel tutorials are best, concise, organized well, easy to understand, and love the music!
I am amazed to see that a so clear explanation can be done and also in such an elegant way!
I am very grateful. All your videos i have watched has been of great help to me.
Much appreciated.
God bless you
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.
Your videos make (re)learning Excel effective through simplicity and compelling style. TY!
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 شكرا
New to ANY sort of technology! Your explanations using Excel are at a level I can actually follow and apply...Thank you!
Short and to the point, awesome. Great class, 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.
Many many thanks! Your way of teaching - combined with your calm voice - is wonderful!
Thanks a lot brother this is what I have been looking for a long time
These tutorials are very helpful and I appreciate your sense of humor (re: romance movies) along the way.
For someone who did not know much going into it, these videos have certainly helped me out a lot.
I’d love to see some Statistics videos. You do a great job explaining thoroughly.
Your tutorial videos are easy and simple to understand. Thanks.
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.
cant stress enough what good teacher you are!!!! thank you
Great tutorials! Please keep them coming... they are very helpful!
You are a great teacher indeed. Love your lectures.
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☀️
I love your training videos! Very helpful!
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.
When you use data validation, source....you can just type the first letter and it will pop up ;) Love your videos!
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 so much for all your excel videos! I wish you well, you're such a kind person.
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.
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
Thank you ! Its very clear, I like the way you present it.
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.
Your videos are great. You are helping many people learn new skills during quarantine. Thank you for all that you do.
Great Tutorials. To the point and well explained. Thank you!
I have NEVER commented on vids, until today. THANK YOU! You have excellent teaching skills.
Amazing explanation. It covered everything the topic encircles.
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
you are such a good teacher. i love every lesson. well articulated
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!
Best tutorial, clear voice, well structured. very well done and THANK YOU.
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.
Great tutorial, clear and compelling. thank you!
Great tuts and fabulous sense of humor!
THANK YOU for the BESTplayslist of excel in all of youtube ! thaaank uuuu
Very helpful. I had figured it out but your video validated that I did it correctly. Thanks.
a very educating piece , i always enjoy using it to improve myself. i am very grateful.
Good job! These videos are very educational. I learned a lot from them as a beginner!
Thanks, Merry Christmas🎄 and Happy New Year
Thanks for those videos, much appreciated.
Very helpful tutorial. Thanks!
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?
Great Value of information and fantastic way of delivering it! Thank you so much!
Thank you! Your videos are really helpful.
Excellent tutorial - explained everything I need to get started👍
I don't like new wave but I love your videos. Very easy to understand.
Thank you for the tutorial. Truly appreciate it!
Great info. Please provide more videos. Keep up the great work again.
Omg this is one of the best tricks I've learned so far! I just love the way you teach. It's informative and entertaining as well!
Thank you so much for your videos, they are really helpful...
I am a first time user and i love your videos, so easy to understand, thank you!
Beautiful tutorial! Loved the series.
Thank you o much for the videos! It is helping tremendously in my new position!
So good. I’m learning both excel skills and movies. I love how u categorized movies by locations. So funny!!
Nice movie list! I love them all. Very informative videos. Thank you.
Great video and very straight to the point. Thank u .
Your videos are very helpful. Thanks
Thank you. You make it so easy. Now I have to start practicing.
Such a nice diction and comprehensible speech. Thank you very much for your videos.
Lol. Best part is new wave “will always be relevant”. Haha great vids man.
Bro 😂😂
@Conner Roberts What the hell man
Excellent tutorials - thank you
Super helpful video. Thank you!
Simple, clear, and to the point Thank you thank you 🙏☺️ you are superb
Wonderful indeed to have your tutorial online. Thank you
Beautifully explained.
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?
Thank you so much! I needed a refresh for a new position I applied too and your videos were the best!
Your videos are awesome, thanks so much.
Very useful video, thank you for your explanation.
Fantastic tutorial
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!
Love this! First time learning about this
watching now May 2020 because im looking for a office job or virtual assistant and all your tutorial may helpful to my future endeavors thank you for this .
thank you! it's 2019 and my clients will now love me even more
Thanks for such a nice lecture sir. You have brilliant teaching skills.
Thanks a lot , great video! very well explained, easy to understand !