Free register and download UseNet downloader, then you can FREE Download from UseNet.

    Download without Limit " Lynda.com - Excel 2007 - Data Validation in Depth " from UseNet for FREE!

Course Content:
Introduction:
Welcome:
Using the exercise files:
1. Controlling the Limits of Numeric Data
Testing for whole numbers and decimals
Using the Input message box
Using the Error Alert tab
2. Setting Up Drop-Down Lists (Pick Lists)
Understanding short list and long list variations
Sequencing and placing lists
Creating multitiered lists
3. Date Controls
Setting date limitations with basic controls
Setting date limitation formulas
4. Time Controls
Limiting time entries with basic controls
Limiting time entries with formulas
5. Text Length Controls
Limiting text length with basic controls
Limiting text length with formulas
6. Specialized Custom Formula Controls
Preventing duplicate entries
Locating data validation rules
7. Conclusion
Goodbye
For Additional info
http://www.lynda.com/tutorial/77849

Related Articles:
Excel