Advanced Excel - Data Validation and Drop-Down Lists

  • Published on Oct 2, 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.
    Movies Mentioned in this Video:
    Dirty Rotten Scoundrels:
    The Princess Bride:
    Young Sherlock Holmes:
    Mystery Men:
    Music Mentioned in this Video:
    Classic Synthpop and New Wave:
    Depeche Mode - Violator:
    Alphaville - Forever Young:
    OMD - Messages: The Best of OMD:
    New Music by Classic Synthpop Bands:
    A-ha - Foot of the Mountain:
    Alphaville - Catching Rays on Giant:
    Underground Modern Synthpop:
    Code 64 - Departure:
    Echo Image - Compuphonic:
    ***Consider supporting Technology for Teachers and Students on Patreon***:
  • Howto & StyleHowto & Style

Comments • 174

  • Lilly Tam
    Lilly Tam 11 hours ago

    THank you so much. I just learned about the magical shift button!

    MDU NTR 9 days ago

    Really cool video, now i can mess with my wife and leave some weird messages when she makes a mistake,lol...

  • James D
    James D 10 days ago


  • sahil doshi
    sahil doshi 11 days ago

    What if the data consist of bold data and normal data, then how to use data validation for the same.
    ------this line is in BOLD
    5,GUPTA DESHPANDE IND. ESTATE----- this one is in normal text

  • kelly Ann
    kelly Ann 13 days ago

    Thank you so much! I needed a refresh for a new position I applied too and your videos were the best!

  • Courtney Stull
    Courtney Stull 14 days ago

    Thank you!! Needed to brush up on my Excel skills. Your videos are the best.

  • keith brown
    keith brown 22 days ago

    last time I checked fix is not fit

  • Ali saciid
    Ali saciid 26 days ago

    you Made me knowledgable, thanks A lot

  • Broke Girl
    Broke Girl 29 days ago


  • Ramachandran Natarajan

    Learning excel is brilliant

  • Ramachandran Natarajan


  • Maria Lazar
    Maria Lazar Month ago

    sir you are just mind blowing

  • U raaxee Caqligaaga

    Please what is that new wave synthpop?.

  • Chloe Chan
    Chloe Chan Month ago

    I can’t seem to do the Shift Drag but I tried INSERT, Shift Cell Down on Science Fiction so it create a blank cell above it for me to input Romance FOR anyone having trouble with it like me

  • Dani Goldblum
    Dani Goldblum Month ago +1

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

  • Ontime Edu
    Ontime Edu Month ago

    *Awesome Speech* 🌟🤗 😘🌟✅

  • Ako Si Belle
    Ako Si Belle Month ago

    You are helping me so much in learning Excel that I'm starting to fall in love with you. Haha. You're funny too, laughed hard at 10:00. Lol.. thanks, keep it up!

  • Melikhaya Mziba
    Melikhaya Mziba 2 months ago +2

    Thank you so much for your videos, they are really helpful...

  • Yvonne DeFoor
    Yvonne DeFoor 2 months ago

    Just watched all three of these videos. My school has been sending us Excel spreadsheets to add to for a few years. I had been taught to create one several years ago but was really in the dark. Thanks for the reteach. Do you have a video about how to merge data from another source?

  • Valentine Vandalism
    Valentine Vandalism 2 months ago

    why do the shift functions not work in excell online

  • Fentolix
    Fentolix 2 months ago +1

    For someone who did not know much going into it, these videos have certainly helped me out a lot.

  • Elinor Jones
    Elinor Jones 2 months ago

    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.

  • Thoko Kasiya
    Thoko Kasiya 2 months ago

    nice videos, it can put someone on top levels in excel

  • Ekole Nelson Betobe
    Ekole Nelson Betobe 2 months ago

    Thanks very much it has been of grate help to me..

  • Luísa Lima
    Luísa Lima 3 months ago +2

    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!

  • James Agblevor
    James Agblevor 3 months ago +1

    YOu videos are great

  • Beach Pest Control Service Inc. - Bed Bug Exterminator

    Thank you for the refresher... I had a question. Assuming my data is a list is names, my list is alphabetized, and saved in a range. I was wondering is there a way to get the drop down data list to open by starting to type the data (a name I know is in the list) that opens the drop down data ribbon in the cell based on the first few characters entered?

    • Hannah
      Hannah 3 months ago

      If your Flash Fill is on it should start autofilling the cell with what it thinks you want based on what's in your data list, not sure about getting the list to auto pop open though by entering name. Flash fill will be in the Data tab > Data Tools > Flash Fill.

  • Sherrie Davidson
    Sherrie Davidson 3 months ago +1

    Thank you o much for the videos! It is helping tremendously in my new position!

  • B H
    B H 3 months ago

    This reminds me of applicant tracking systems that annoy the hell out of people by deciding what can be entered onto an application.

  • KamikaziFailure_
    KamikaziFailure_ 4 months ago +2

    I slept through class when we learned this so I need this information for my exam tomorrow.

  • Isaac Zawolo
    Isaac Zawolo 4 months ago

    Great and informative.

  • Hazem Ali
    Hazem Ali 4 months ago

    many thanks

  • Blanca Hawkins
    Blanca Hawkins 4 months ago +1

    Super helpful video. Thank you!

  • Joseph Cosgrove
    Joseph Cosgrove 4 months ago +1

    It may be worth pointing that list will work regardless of where it is put. Great videos.

  • Alisa Rocha
    Alisa Rocha 4 months ago +2

    Your videos are awesome, thanks so much.

  • John Klimek
    John Klimek 4 months ago +1

    Hello, I cannot say how grateful I am for this :) It is really awesome work, man. I did not know how much you can play with it, and what you can do to prevent some accidental incidents to happen. It reminds me a bit life itself :D, but this is a prevention in terms of using the Excel.
    Anyway, I am now more smart, I make notes with everyone video you made.
    I believe this helps anyone who wants to learn in MS Office :)
    Thank you and keep your work up :)
    Hello from Prague :)

  • Ysidro Garcia
    Ysidro Garcia 5 months ago +2

    excel is like programming with a GUI lol

  • Farru shariff
    Farru shariff 5 months ago +4

    Your tips and techniques are a good refresher. thanks

  • Leo the Learner
    Leo the Learner 5 months ago

    5:30 that maximum length is applied only on new input, as an exemple cell A13, is an older input and has a length greater than 22

  • Communication
    Communication 5 months ago +1

    Your tutorial videos are easy and simple to understand. Thanks.

  • Dixon Peer
    Dixon Peer 5 months ago +2

    The best genre of music 1974 and later???

  • Wayne Jack
    Wayne Jack 5 months ago +1

    Do any of your videos show how to do standard deviation automatically?

  • Chris Glesner
    Chris Glesner 6 months ago +1

    Beautiful tutorial! Loved the series.

  • Rushaid Khan
    Rushaid Khan 6 months ago +2


  • Lucas Rye
    Lucas Rye 6 months ago +1

    Ima go ahead a stop you right there buddy. Synth pop is not the best genre of music. I am offended. 🤦🏻‍♂️

  • Jerry Polete
    Jerry Polete 6 months ago +2

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

  • Apathy Express
    Apathy Express 6 months ago +4

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

  • Dex Morrison
    Dex Morrison 6 months ago

    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.

  • Tomas Weiskog
    Tomas Weiskog 6 months ago

    Great videos. Really useful. Also, sweet music collection.

  • Angelique van Tilborg
    Angelique van Tilborg 6 months ago

    keep up the good work, very clear video, thanks!

  • Arindam Maity
    Arindam Maity 7 months ago +2

    Fantastic tutorial

  • Liliana Forfota
    Liliana Forfota 7 months ago +2

    I like your English speaking by the way more than those lesons :)

  • Tatiana B.
    Tatiana B. 7 months ago +1

    cant stress enough what good teacher you are!!!! thank you

  • Emmy Wong
    Emmy Wong 7 months ago +1

    Thank you for sharing, it a great lesson.

  • Annie Are You Woke Eh?
    Annie Are You Woke Eh? 7 months ago +2

    Synthpop: you don't know you're a musician until you've tried.

  • Aydin Valiyev
    Aydin Valiyev 7 months ago

    Please help, I need to sort a list of words in alphabetic order, but not from left side of the words as usual, but from the right side, endings of words.

  • ArtisticMystic
    ArtisticMystic 7 months ago

    Long boring and achieved nothing. The process didn't work for me.

  • Corey Rowell
    Corey Rowell 7 months ago

    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?

  • Natalee Ivanov Kibbar
    Natalee Ivanov Kibbar 8 months ago

    learn alot of tricks, thank you

  • Nayana Nagaraja
    Nayana Nagaraja 8 months ago

    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.