中文名: Lynda.com 出品Excel 2007深入學習數據驗證 視頻教程
英文名: Lynda.com.Excel.2007.Data.Validation.In.Depth
資源格式: 光盤鏡像
學校: Lynda.com
主講人: Dennis Taylor
發行日期: 2011年2月28日
地區: 美國
對白語言: 英語
文字語言: 英文
簡介:

語言：英語
網址：http://www.lynda.com/tutorial/77849
類別：教程
（xuehui@TLF）
Lynda.com 出品的時長58分鐘的 Excel 2007: 深入學習數據驗證 視頻教程。由Dennis Taylor講解怎樣使用Excel的數據驗證工具來管理什麼樣的用戶可以輸入數據到工作簿上，並確保加入的數據一致、准確性。內容包括創建下拉式列表，防止重復項，控制數字數據、日期和時間格式，以及把文本輸入到工作表中。教程附帶練習文件。
In Excel 2007: Data Validation in Depth, author Dennis Taylor shows how to use the data validation tools in Excel to control how users can input data into workbooks and ensure data is entered consistently and accurately. The course covers creating dropdown lists, preventing duplicate entries, and controlling the format of numeric data, dates and times, and text entered into worksheets. Exercise files are included with the course.
Topics include:
Testing for whole numbers and decimals
Using the input message box
Sequencing and placing lists
Creating multi-tiered lists
Setting date and time limitations
Limiting text length
Locating data validation rules
Course name:
Excel 2007: Data Validation in Depth
Author:
Dennis Taylor
Duration (hh:mm:ss):
00:58:00
Released on:
2/28/2011
Exercise files:
Yes

下載鏈接來自TLF
未經過安裝測試與安全檢測，使用者後果自負與本論壇無關
軟體版權歸原作者及其公司所有，如果你喜歡，請購買正版
目錄:
Introduction 00:01:09
Welcome 00:00:46
Using the exercise files 00:00:23
00:08:46
1. Controlling the Limits of Numeric Data Testing for whole numbers and decimals 00:04:30
Using the Input message box 00:02:04
Using the Error Alert tab 00:02:12
00:17:47
2. Setting Up Drop-Down Lists (Pick Lists) Understanding short list and long list variations 00:04:42
Sequencing and placing lists 00:08:15
Creating multitiered lists 00:04:50
00:09:05
3. Date Controls Setting date limitations with basic controls 00:02:45
Setting date limitation formulas 00:06:20
00:08:15
4. Time Controls Limiting time entries with basic controls 00:02:47
Limiting time entries with formulas 00:05:28
00:06:57
5. Text Length Controls Limiting text length with basic controls 00:02:54
Limiting text length with formulas 00:04:03
00:06:07
6. Specialized Custom Formula Controls Preventing duplicate entries 00:03:10
Locating data validation rules 00:02:57
00:00:30
Conclusion Goodbye 00:00:30