filmov
tv
Excel Data Validation - Drop-down lists & More in a simple database form!
Показать описание
💡 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 💥
0:13:08
Advanced Excel - Data Validation and Drop-Down Lists
0:15:42
Create SMART Drop Down Lists in Excel (with Data Validation)
0:00:36
Data Validation in Excel‼️ #excel
0:00:20
How to add Dropdown list in Google Sheet? ( In 20 Seconds) | Data Validation trick #shorts
0:01:00
Data Validation Drop Down List - How to make drop down list in excel
0:03:22
How to Create a Drop-Down List in Excel
0:02:24
Data Validation Drop-Down List with Excel Table Dynamic Range
0:00:12
Drop-down list without data validation
0:01:00
Easier Data Validation with Dynamic Drop-down List in Excel
0:07:16
Create multiple dependent drop-down lists in Excel [EASY]
0:16:17
3 Ways to Automatically Update Drop Down Lists in Excel - Data Validation
0:01:01
How to create a drop-down list in Microsoft Excel
0:03:50
Excel Create Dependent Drop Down List Tutorial
0:10:07
Data Validation Drop Down List with Excel Table Dynamic Range
0:31:06
Data Validation in Excel | Drop-down lists | FREE Excel Course
0:00:56
How to Color the Drop Down List in Excel
0:00:35
Excel Data Validation Drop-Down List Hack! Save Time with This Trick!
0:00:25
Data Validation in Excel || Providing drop down facility from a list
0:00:54
Multiple Dependent Drop Down List In Excel! Learn this in one minute! 😎 #excel #exceltips
0:01:23
How to create drop down list in excel with multiple selections
0:01:00
Creating Dropdown Lists using Data Validation in Excel
0:01:15
How to apply data validation to cells in Microsoft Excel
0:00:47
Create list with Data Validation
0:14:49
Extract UNIQUE Items for Dynamic Data Validation Drop Down List
Комментарии