Advanced Excel - Data Validation and Drop-Down Lists

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: https://www.youtube.com/channel/UCYUPLUCkMiUgiyVuluCc7tQ/join ***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/technologyforteachersandstudents My entire playlist of Excel tutorials: http://bit.ly/tech4excel Movies Mentioned in this Video: Dirty Rotten Scoundrels: http://amzn.to/2xTpck1 The Princess Bride: http://amzn.to/2yk3tDc Ladyhawke: http://amzn.to/2xOhLsA Stardust: http://amzn.to/2yjJvs9 Young Sherlock Holmes: http://amzn.to/2xaJJNv Mystery Men: http://amzn.to/2yRmQ3r Music Mentioned in this Video: Classic Synthpop and New Wave: Depeche Mode - Violator: http://amzn.to/2utJMqp Alphaville - Forever Young: http://amzn.to/2tl4gle OMD - Messages: The Best of OMD: http://amzn.to/2uyz1Ct New Music by Classic Synthpop Bands: A-ha - Foot of the Mountain: http://amzn.to/2tbfrsv Alphaville - Catching Rays on Giant: http://amzn.to/2tbD445 Underground Modern Synthpop: Code 64 - Departure: http://amzn.to/2tbEtbd Echo Image - Compuphonic: http://amzn.to/2uEvzr4