Lynda Com Excel 2010 Data Validation In Depth  英文版     CD


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





目錄:


Introduction
Welcome00:00:45
Usingtheexercisefiles00:00:24
00:08:50
1.ControllingtheLimitsofNumericData
Testingforwholenumbersanddecimals00:03:58
UsingtheInputmessagebox00:02:18
UsingtheErrorAlerttab00:02:34
00:15:17
2.SettingUpDrop-DownLists(PickLists)
Understandingshortlistandlonglistvariations00:04:10
Sequencingandplacinglists00:06:17
Creatingmultitieredlists00:04:50
00:09:10
3.DateControls
Settingdatelimitationswithbasiccontrols00:02:08
Settingdatelimitationformulas00:07:02
00:09:07
4.TimeControls
Limitingtimeentrieswithbasiccontrols00:02:54
Limitingtimeentrieswithformulas00:06:13
00:09:13
5.TextLengthControls
Limitingtextlengthwithbasiccontrols00:03:51
Limitingtextlengthwithformulas00:05:22
00:06:27
6.SpecializedCustomFormulaControls
Preventingduplicateentries00:03:14
Locatingdatavalidationrules00:03:13
00:00:32
Conclusion
Goodbye00:00:32