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:
   / @techteachersandstudents  
***Consider supporting Technology for Teachers and Students on Patreon***:   / 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