Advanced Excel - Data Validation and Drop-Down Lists

Movies Mentioned in this Video:

Music Mentioned in this Video:
Classic Synthpop and New Wave:

New Music by Classic Synthpop Bands:

Underground Modern Synthpop:

[Low.Key.Music]

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.

[armydex]

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.

[karenzhou]

All your videos are so well explained. Thanks for the great learning resource.

[uni-veegecco]

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

[ndelpurg]

all your videos are great teaching devices many thanks!

[BlazeBlitzkrieg]

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!

[arbitrarylib]

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.

[ASMRconKiki]

This is so clear and well explained. I feel like you opened a world in front of me! Thank you for this video.

[stevewierzbicki]

OMG, I Absolutely Love your website; I feel as though I am Back in School and listening to everything also watching it actually happen.

[iqraacho]

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 شكرا

[tracyprestwood]

When you use data validation, source....you can just type the first letter and it will pop up ;) Love your videos!

[TUPSinvestigation]

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!

[timwilliams]

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!!!!

[apathyexpress]

Your continued commentary on synthpop cracked me up. Great vid.

[jjb]

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 :-)

[danigoldblum]

I am amazed to see that a so clear explanation can be done and also in such an elegant way!

[jerrypolete]

Nice movie collection, love older movies as well as older music. Great job thank you.

[chimesilas]

I am very grateful. All your videos i have watched has been of great help to me.
Much appreciated.
God bless you

[joshcousins]

This man's love of synthpop is legendary

[debrasmith]

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!!