資料介紹

• 辦公軟件與office教程
• 計算機資料

語言：英語
網址：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