xyz 軟體補給站

xuehui@TLF）
Lynda.com 出品的時長59分鐘的 Excel 2010: 深入學習數據驗證 視頻教程。由Dennis Taylor講解怎樣使用Excel的數據驗證工具來管理什么樣的用戶可以輸入數據到工作簿上，并確保加入的數據一致、準確性。內容包括創建下拉式列表，防止重復項，控制數字數據、日期和時間格式，以及把文本輸入到工作表中。教程附帶練習文件。





目錄:


Introduction
Welcome 00:00:45
Using the exercise files 00:00:24
00:08:50
1. Controlling the Limits of Numeric Data
Testing for whole numbers and decimals 00:03:58
Using the Input message box 00:02:18
Using the Error Alert tab 00:02:34
00:15:17
2. Setting Up Drop-Down Lists (Pick Lists)
Understanding short list and long list variations 00:04:10
Sequencing and placing lists 00:06:17
Creating multitiered lists 00:04:50
00:09:10
3. Date Controls
Setting date limitations with basic controls 00:02:08
Setting date limitation formulas 00:07:02
00:09:07
4. Time Controls
Limiting time entries with basic controls 00:02:54
Limiting time entries with formulas 00:06:13
00:09:13
5. Text Length Controls
Limiting text length with basic controls 00:03:51
Limiting text length with formulas 00:05:22
00:06:27
6. Specialized Custom Formula Controls
Preventing duplicate entries 00:03:14
Locating data validation rules 00:03:13
00:00:32
Conclusion
Goodbye 00:00:32