This Excel tutorial shows how to set up a pick list using data validation and other features. Watch more at http://www.lynda.com/Excel-2007-tutorials/Data-Validation-in-Depth/77849-2.html?utm_medium=viral&utm_source=youtube&utm_campaign=videoupload-77849-0203
This specific tutorial is just a single movie from chapter two of the Excel 2007: Data Validation in Depth course presented by lynda.com author Dennis Taylor. The complete Excel 2007: Data Validation in Depth course has a total duration of 1 hour, and covers creating dropdown lists, preventing duplicate entries, and controlling the format of numeric data, dates and times
Excel 2007: Data Validation in Depth table of contents:
Introduction
1. Controlling the Limits of Numeric Data
2. Setting Up Drop-Down Lists (Pick Lists)
3. Date Controls
4. Time Controls
5. Text Length Controls
6. Specialized Custom Formula Controls
Conclusion