Excel Data Validation - Drop-down lists & More in a simple database form!
💻 Check out my NEW online course Excel Analyst https://claritix.co.uk/excel-analyst
🤝 Connect/Follow me on LinkedIn: http://bit.ly/MyLinkedIn_Dan
💡 GREEN: Intermediate-level
► Drop-down Lists in Excel are something EVERYONE loves, a bit like cute puppies 🐶 and they ALWAYS want to know how to create them. Well look no further, in this video we explore the world of Data Validation!
► But it doesn't stop at just Lists, there are an array of options including Max/Min values, Whole Numbers vs Decimals, Dates... We even look at how we can create formula-driven Data Validation, and customise Input Messages & Error Alerts to warn that guy we sit next too that he's inputting the wrong thing again 🙄
► But seriously, Data Validation is really important in spreadsheets and modelling, particularly where others will be entering data/assumptions, as they restrict what can be entered in those inputs to only reasonable or acceptable values 👮
► Btw, if you like this video then you'll really, really like the follow on video, Data Validation Part 2, where we look at Dynamic Drop-down Lists - they are 🎉 And it's all in the context of a spa business. What could be more relaxing? 🏖️
💥 Related Videos 💥
★ INDEX & MATCH Part 1 - Ultimate lookup solution: • Video
★ Data Validation Part 2 - You'll LOVE dynamic drop-downs: • Excel DYNAMIC Drop-downs in an Order Form....