v

您的位置:VeryCD教育计算机


《Excel 2007: 日期和时间函数功能教程》(Excel 2007: Working with Dates and Times)[光盘镜像]

  • 状态: 精华资源
  • 摘要:
    发行日期2010年07月28日
    对白语言英语
    文字语言英文
  • 时间: 2010/08/28 02:09:54 发布 | 2010/09/04 12:39:44 更新
  • 分类: 教育  计算机 

xiaochenjia

精华资源: 673

全部资源: 675

相关: 分享到新浪微博   转播到腾讯微博   分享到开心网   分享到人人   分享到QQ空间   订阅本资源RSS更新   美味书签  subtitle
该内容尚未提供权利证明,无法提供下载。
中文名Excel 2007: 日期和时间函数功能教程
英文名Excel 2007: Working with Dates and Times
资源格式光盘镜像
发行日期2010年07月28日
地区美国
对白语言英语
文字语言英文
简介

IPB Image

资源简介:

Lynda出品的Excel 2007: Working with Dates and Times. Excel 2007时间和日期函数功能方面的教程.

教程时长:1小时27分

主讲: Dennis Taylor

教学光盘提供有练习素材.

Description:

In Excel 2007: Working with Dates and Times, Dennis Taylor shares his solutions for optimizing the use of dates and times in Excel 2007. This course explains what's going on behind the scenes when Excel stores dates and times, gives tips for entering dates and times, and shows options for date and time formatting. It also demonstrates the various date and time functions and shows how to calculate with dates and times in a range of scenarios. Exercise files are included with the course.

Topics include:

Understanding how Excel records and stores dates and times
Looking at standard date/time entry options and acceptable alternatives
Using the TODAY and NOW functions
Customizing date formats
Exploring keyboard shortcuts
Formatting time for hours over 24
Calculating differences across dates and times
Rounding calculations
Working with holidays
Validating with dates
Converting formatted dates to usable data

截图预览:

IPB Image



目录

Introduction 01:42
Welcome 01:14
Using the exercise files 00:28
06:19 1. Excel's Date/Time System
Understanding how Excel records and stores dates 04:15
Understanding how Excel records and stores times 02:04
15:19 2. Creating Date/Time Entries
Looking at standard date/time entry options and acceptable alternatives 05:19
Using instant date/time entry 01:17
Using TODAY and NOW functions for dynamic date/time entry 03:02
Using Auto Fill to enter date and time series 05:41
08:03 3. Date/Time Formatting
Exploring keystroke shortcuts 02:12
Formatting time for hours over 24 03:04
Creating custom date formatting 02:47
18:51 4. Excel's Date/Time Functions
EOMONTH and EDATE: Setting ends of months and future/past dates 04:07
DATEDIF: Calculating date differences by year, month, day, and more 04:15
WEEKDAY: Determining the day of the week 02:13
NETWORKDAYS: Calculating working days 02:50
WORKDAY: Calculating an ending date 02:09
DATEVALUE and TIMEVALUE: Converting text entries into dates and times 03:17
21:34 5. Calculating with Dates and Times
Calculating date differences across days, months, and years 01:44
Calculating time differences within and across days 05:34
Calculating fiscal years and quarters 05:44
Rounding time calculations to convenient intervals 03:48
Using times with currency calculations 02:44
Calculating holidays (Labor Day, Thanksgiving, Memorial Day, etc.) 02:00
15:30 6. Using Dates and Times with Excel Commands
Using special date filters with date data 03:15
Using date controls in data validation rules 05:30
Using date functions in data validation rules 03:39
Converting unusually formatted dates into usable data (text to columns) 03:06
00:29 Conclusion
Goodbye 00:29

引用
资源来自网络收集 未经过一一的质量 安全等检测
只是把收集的资源和各位驴友分享 仅作网络学习交流使用 请勿用于商业用途 !
希望各位下载的驴友能多多参与分流保源 happy.gif

正在读取……

这里是其它用户补充的资源(我也要补充):

暂无补充资源
正在加载,请稍等...

点击查看所有26网友评论

 

(?) [公告]留口水、评论相关规则 | [活动]每日签到 轻松领取电驴经验

    小贴士:
  1. 类似“顶”、“沙发”之类没有营养的文字,对勤劳贡献的楼主来说是令人沮丧的反馈信息。
  2. 提问之前请再仔细看一遍楼主的说明,或许是您遗漏了。
  3. 勿催片。请相信驴友们对分享是富有激情的,如果确有更新版本,您一定能搜索到。
  4. 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦,又没人会搭理,于人于己都无利。
  5. 如果您发现自己的评论不见了,请参考以上4条。