Tutorials
Course Contents
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
Fileserve.com
http://www.fileserve.com/file/5v5UzMT/Lynda.com.Excel.2007.Data.Validation.In.Depth-iRONiSO.rar
Filesonic.com
http://www.filesonic.com/file/181500151/Lynda.com.Excel.2007.Data.Validation.In.Depth-iRONiSO.rar
Fileserve.com
http://www.fileserve.com/file/5v5UzMT/Lynda.com.Excel.2007.Data.Validation.In.Depth-iRONiSO.rar
Filesonic.com
http://www.filesonic.com/file/181500151/Lynda.com.Excel.2007.Data.Validation.In.Depth-iRONiSO.rar
Lynda.com Excel 2007 Data Validation In Depth iRONiSO
Free Downloads Lynda.com Excel 2007 Data Validation In Depth - iRONiSO, Shareware,
Ftp, Direct links,
RapidShare, Megaupload, DepositFiles,
HotFile, Uploading, Easy-Share.