Advanced Excel - Data Validation and Drop-Down Lists
Вставка
- Опубліковано 7 вер 2024
- 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. Join this channel to get access to perks:
/ @techteachersandstudents
***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
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
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
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
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
This is so clear and well explained. I feel like you opened a world in front of me! Thank you for this video.
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 :-)
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 great teaching devices many thanks!
ua-cam.com/video/alV9Dn7YIfA/v-deo.html
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 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!
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 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
Another good idea to not affect the list is protecting those cells by going to Review and Protect sheets option. You can also password protect it if it's that important.
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.
It may be worth pointing that list will work regardless of where it is put. Great videos.
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☀️
You deserve the world for creating these videos.
All your videos are so well explained. Thanks for the great learning resource.
Thank you. You make it so easy. Now I have to start practicing.
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!
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 .
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.
For someone who did not know much going into it, these videos have certainly helped me out a lot.
Many thanks watched all 3 videos have better understanding of excel
Lol. Best part is new wave “will always be relevant”. Haha great vids man.
Bro 😂😂
@Conner Roberts What the hell man
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!
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
Many many thanks! Your way of teaching - combined with your calm voice - is wonderful!
Your videos make (re)learning Excel effective through simplicity and compelling style. TY!
One video and I'm sold. U sir are a great inspiration 👏 I took 1 class and my non profit could no longer afford cont education. So I learn only own to help. Thank you. I will look into your video catalog to see where to start in case I missed anything... if you have any pointers on how to follow and progress. Let me know 🙏 pls. Thank you
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.
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.
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 شكرا
Thanks a lot brother this is what I have been looking for a long time
I don't like new wave but I love your videos. Very easy to understand.
Your tutorials are so easy to follow up and interesting because of the way you teach
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!!
Had to catch up with my high school daughter's proficiency ... your navigational / application videos have been great!!
cant stress enough what good teacher you are!!!! thank you
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.
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 tutorial videos are easy and simple to understand. Thanks.
I benefit alot from your tutorial. Good teaching
I have NEVER commented on vids, until today. THANK YOU! You have excellent teaching skills.
THANK YOU for the BESTplayslist of excel in all of youtube ! thaaank uuuu
I had a problem with my excel data, I did not find anyone to help me. after watching this video, I know how to do well.
thank you so much. your fun from Afghanistan.
You were born to teach :) Thanks for the videos!
Very helpful. I had figured it out but your video validated that I did it correctly. Thanks.
Using your tutorials for Libre Office's Calc(their version of Excel) and this tutorial works for that too
These tutorials are very helpful and I appreciate your sense of humor (re: romance movies) along the way.
loved the video. this is exactly what I need right now.
I am amazed to see that a so clear explanation can be done and also in such an elegant way!
Very useful video, thank you for your explanation.
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!
a very nice tutorial specially for beginners. Can i have the link for entire courses in ascending order from beginners to advance level.
Tommorow is my practical test
I am here list validation but i found both
Thank u a lot
U helped me
Good job! These videos are very educational. I learned a lot from them as a beginner!
very nice video... explained in a simple way
I must confess you are indeed great in your ways of teaching, thanks so much and more Grace as you keep helping people 👏👏😊
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 soo much for explaining in a great way😊
Your videos are great. You are helping many people learn new skills during quarantine. Thank you for all that you do.
Awesome, very easy to understand! Thanks.......
got myself new knowledge of Excel in this Self quarantine situation:) Thankyou so much
Me too!
I am very grateful. All your videos i have watched has been of great help to me.
Much appreciated.
God bless you
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?
Your videos are very helpful. Thanks
this was a huge help - thank you. I have a self learning manual but you just cut down so much time on understanding Data validation
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?
a very educating piece , i always enjoy using it to improve myself. i am very grateful.
Really helpful. I do know a fair amount but have picked up some more tips. Thank you
Beautifully explained.
Thanks a lot I understood much more better than my teacher ❤
Such a nice diction and comprehensible speech. Thank you very much for your videos.
Couldn't Princess Bride👰 be considered romance as well as fantasy? Your videos 📼 are good for those of us just getting familiar with Excel. I have found them helpful
hi
I’d love to see some Statistics videos. You do a great job explaining thoroughly.
This is very helpful. I'm an EXCEL novice. Thanks.
So good. I’m learning both excel skills and movies. I love how u categorized movies by locations. So funny!!
This tutorial is AMAZING
Wonderful indeed to have your tutorial online. Thank you
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!
I just learnt how to click and drag, thank you
Great info. Please provide more videos. Keep up the great work again.
Thank you so much for your videos, they are really helpful...
Fantastic tutorial
Great Value of information and fantastic way of delivering it! Thank you so much!
Best tutorial, clear voice, well structured. very well done and THANK YOU.
Learning this is like cavemen discovering fire.
Plz also tell how yo select cell by using left or right click
For beginners it will b good
And u r doing a great job
Thank you so much. Your videos are so useful 🙏💞
Thank you, sir! This is a great help.
Hello,
Thank you very much for the simply explained information.
Could you please write down the tips in description. It will be useful when I want to review it because it is difficult to find it without watching the whole video.
Best wishes !
These videos are great, thank you !
Sir,
Thanks a lot for this valuable video...