Summary of Create SMART Drop Down Lists in Excel (with Data Validation)

00:00:00 - 00:15:00

This video demonstrates how to create smart drop-down lists in Excel using data validation. This allows the user to ensure that only valid entries are selected, by constraining the input values to a certain range.

• 00:00:00 This video demonstrates how to create a smart drop-down list in Excel, using data validation to ensure that input values are entered correctly.
• 00:05:00 This video shows how to use Excel's data validation features to ensure that data entered into a drop-down list is within the constraints defined for that cell. For example, if the cell contains a date, the user must select a future date.
• 00:10:00 This video demonstrates how to create SMART drop down lists in Excel using data validation. The user first chooses a start and end date for the list, then inputs a project number. They also define minimum and maximum values for the list, and provide an error alert for if the input is not within the range. Next, they copy and paste the data validation check into other cells, and highlight the area where people will be importing the list. Finally, they make sure that the validation is in place and ready to use.
• 00:15:00 This video demonstrates how to create smart drop-down lists in Excel, using data validation to ensure that only valid entries are selected.