Data Validation in Excel - Drop Down Menus, Lists, etc.

by TeachExcel · 15 videos (1 unavailable)

Total watch time

2h 34m

at speed · exactly 2 hours, 33 minutes, 49 seconds at 1×

2h 33m 49s
1.25×2h 3m 3s
1.5×1h 42m 33s
1.75×1h 27m 54s
1h 16m 55s
Average video10m 15s
Longest20m 53s
Shortest1m 9s
Compare Open on YouTube JSON

Plan to finish

About 3 days at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

Days

At one hour a day, every day, this playlist takes about 3 days. Turn on JavaScript to plan around your week.

Videos (16)

2h 34m in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser.

Videos to
Watched
1 Data Validation 4 - Create Multiple Dependent Drop Down Menus With Complex Names in Excel 8:36 2009-12-16
2 Private video
3 Data Validation 2 - Create Drop Down Menus From Source Data on Separate Tabs in Excel 4:58 2009-12-16
4 Data Validation 1 - Create Drop Down Menus in Excel 5:51 2009-12-16
5 Limit Date input in a Spreadsheet in Excel (Allow only Future Dates) 8:51 2012-12-17
6 Excel - Allow only Text or only Numbers Entered into a Cell in Excel - Custom Formulas 5:11 2013-07-24
7 5 Data Validation Tricks - Workbook Included 19:12 2018-04-11
8 3 Ways to Automatically Update Drop Down Lists in Excel - Data Validation 16:17 2020-02-18
9 Data Validation in Excel - A Guide 20:53 2020-06-16
10 Data Validation in Excel - A Guide 20:53 2020-06-16
11 Guide to Making Drop Down List Menus in Excel 14:11 2020-07-07
12 Automatically Updating Dependent Drop Down List Menus in Excel 11:34 2020-11-17
13 Ignore Blanks in Data Validation Lists in Excel 10:39 2021-08-03
14 Data Validation List with Dynamic Arrays in Excel - EQ 95 1:09 2021-08-05
15 Unique Drop Down Lists that Automatically Update with New Values 2:01 2023-04-25
16 Always Visible Drop Down Arrow in Excel 3:33 2023-05-23

Embed a badge

Show the watch time in a README or course description — it links back here and updates itself

Watch time: 2h 34m · 15 videos

Markdown
[![Watch time: 2h 34m · 15 videos](https://playlistduration.com/badge/playlist/PL8DDE4BC70A8F3E71.svg)](https://playlistduration.com/playlist/PL8DDE4BC70A8F3E71)
HTML
<a href="https://playlistduration.com/playlist/PL8DDE4BC70A8F3E71"><img src="https://playlistduration.com/badge/playlist/PL8DDE4BC70A8F3E71.svg" alt="Watch time: 2h 34m · 15 videos" width="203" height="20"></a>

Add ?speed=1.5 to the image URL for the time at that speed, ?label=Course to change the left text, or ?style=flat-square for square corners.

Want the numbers themselves? GET https://playlistduration.com/api/v1/playlist/PL8DDE4BC70A8F3E71 returns them as JSON — free, no key. API docs →

Data from the YouTube Data API as of 2026-09-22 (cached). Private or deleted videos are excluded from totals.