《Lynda.com 出品Excel 2007深入学习数据验证 视频教程》(Lynda.com.Excel.2007.Data.Validation.In.Depth)[光盘镜像]
电驴资源
电驴资源简介
简介:
/thumb.jpg)
语言:英语
网址: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
/thumb.jpg)
下载链接来自TLF
未经过安装测试与安全检测,使用者后果自负与本论坛无关
软体版权归原作者及其公司所有,如果你喜欢,请购买正版
语言:英语
网址: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
未经过安装测试与安全检测,使用者后果自负与本论坛无关
软体版权归原作者及其公司所有,如果你喜欢,请购买正版
