Advanced Excel - Data Validation and Drop-Down Lists
HTML-код
- Опубликовано: 1 окт 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 
Хобби
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.
All your videos are so well explained. Thanks for the great learning resource.
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 great teaching devices many thanks!
ruclips.net/video/alV9Dn7YIfA/видео.html
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 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.
This is so clear and well explained. I feel like you opened a world in front of me! Thank you for this video.
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!
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
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 continued commentary on synthpop cracked me up. Great vid.
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 amazed to see that a so clear explanation can be done and also in such an elegant way!
Nice movie collection, love older movies as well as older music. Great job thank you.
This man's love of synthpop is legendary
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!!
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☀️
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!
These tutorials are very helpful and I appreciate your sense of humor (re: romance movies) along the way.
Your videos make (re)learning Excel effective through simplicity and compelling style. TY!
Your excel tutorials are best, concise, organized well, easy to understand, and love the music!
I’d love to see some Statistics videos. You do a great job explaining thoroughly.
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?
New to ANY sort of technology! Your explanations using Excel are at a level I can actually follow and apply...Thank you!
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?
Short and to the point, awesome. Great class, thank you!
I love your training videos! Very helpful!
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!
Great tutorials! Please keep them coming... they are very helpful!
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.
I have NEVER commented on vids, until today. THANK YOU! You have excellent teaching skills.
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.
I must confess you are indeed great in your ways of teaching, thanks so much and more Grace as you keep helping people 👏👏😊
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.
Beautiful tutorial! Loved the series.
Many many thanks! Your way of teaching - combined with your calm voice - is wonderful!
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.
Best tutorial, clear voice, well structured. very well done and THANK YOU.
cant stress enough what good teacher you are!!!! thank you
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.
Your tutorial videos are easy and simple to understand. Thanks.
You deserve the world for creating these videos.
Thank you so much for all your excel videos! I wish you well, you're such a kind person.
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
You are a great teacher indeed. Love your lectures.
Nice video tutorials. Am currently facing challenges anytime I create a data drop-down in MSExcel 2013 . After I have saved, closed and re-opened my file, the Drop-down doesn't work again. Can you pls help.
I've been going video to video trying to understand but your channel is the one that really did it. Thank you sir.
Great information, thank you! Can you apply the data validation (text input) into the graph as well, if not are there any similar tools that can be used?
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 were born to teach :) Thanks for the videos!
Thank you ! Its very clear, I like the way you present it.
Great Tutorials. To the point and well explained. Thank you!
So good. I’m learning both excel skills and movies. I love how u categorized movies by locations. So funny!!
It may be worth pointing that list will work regardless of where it is put. Great videos.
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! :)
Thanks, Merry Christmas🎄 and Happy New Year
Very helpful. I had figured it out but your video validated that I did it correctly. Thanks.
Good job! These videos are very educational. I learned a lot from them as a beginner!
Lol. Best part is new wave “will always be relevant”. Haha great vids man.
Bro 😂😂
@Conner Roberts What the hell man
Amazing explanation. It covered everything the topic encircles.
Thank you!! Needed to brush up on my Excel skills. Your videos are the best.
Thank you so much for your videos, they are really helpful...
Your videos are great. You are helping many people learn new skills during quarantine. Thank you for all that you do.
I currently am trying to get my degree in accounting. I started to look for entry level jobs and saw proficiency in excel was a requirement. I’ve learned so much in these videos! To be certified in excel how much more would I need to learn?
a very educating piece , i always enjoy using it to improve myself. i am very grateful.
Thank you o much for the videos! It is helping tremendously in my new position!
you are such a good teacher. i love every lesson. well articulated
Your videos are awesome, thanks so much.
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 .
Very helpful tutorial. Thanks!
you're a hero. I'm binging your excel videos so that I can start sorting my steaming pile of overwhelming work tomorrow 😵
Learning this is like cavemen discovering fire.
Love your videos!
Best instruction!! Very helpful ! Thank you.
Such a nice diction and comprehensible speech. Thank you very much for your videos.
Great info. Please provide more videos. Keep up the great work again.
thank you! it's 2019 and my clients will now love me even more
Super helpful video. Thank you!
Thank you! Your videos are really helpful.
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
Great Value of information and fantastic way of delivering it! Thank you so much!
Great videos. You threw some good jokes in there too
I am a first time user and i love your videos, so easy to understand, thank you!
thank you do much, these tutorials helped me alot, you truly are the best excel teacher on youtube !
Thanks for those videos, much appreciated.
Great tuts and fabulous sense of humor!
Thanks you for the great explanation, I been watching many videos, and this one was just perfect, I was able to do what I needed.
Excellent tutorial - explained everything I need to get started👍
Great tutorial, clear and compelling. thank you!
Excellent tutorials - thank you
Thanks for such a nice lecture sir. You have brilliant teaching skills.
Thank you for sharing, it a great lesson.
Nice movie list! I love them all. Very informative videos. Thank you.
Simple, clear, and to the point Thank you thank you 🙏☺️ you are superb