【Lynda】Excel 2007: Working with Dates and Times【CHN】中英文字幕[SRT]

作者: acely. 分类: Lynda中文字幕, ◇ 商业办公

==========教程信息=====================================================
教程名称:Excel 2007: Working with Dates and Times
作者:Dennis Taylor
主题:Business, Spreadsheets
使用软件:Excel 2007
难度等级:中级
时长: 1h 27m
发布日期: Jul 28, 2010

┏ACELY STUDIO,2012
┃更多资源请访问
┃◆唯一发布站:ACELY.CN
┗◆我的博客:http://blog.sina.com.cn/u/1991840741

==========教程目录文件列表=============================================
Excel 2007- Working with Dates and Times[SRT]
├─◆0. Introduction
│ └─◇ 0001 Welcome.srt
│ └─◇ 0002 Using the exercise files.srt
├─◆1. Excel’s Date Time System
│ └─◇ 0101 Understanding how Excel records and stores dates.srt
│ └─◇ 0102 Understanding how Excel records and stores times.srt
├─◆2. Creating Date Time Entries
│ └─◇ 0201 Looking at standard date time entry options and acceptable alternatives.srt
│ └─◇ 0202 Using instant date time entry.srt
│ └─◇ 0203 Using TODAY and NOW functions for dynamic date time entry.srt
│ └─◇ 0204 Using Auto Fill to enter date and time series.srt
├─◆3. Date Time Formatting
│ └─◇ 0301 Exploring keystroke shortcuts.srt
│ └─◇ 0302 Formatting time for hours over 24.srt
│ └─◇ 0303 Creating custom date formatting.srt
├─◆4. Excel’s Date Time Functions
│ └─◇ 0401 EOMONTH and EDATE- Setting ends of months and future past dates.srt
│ └─◇ 0402 DATEDIF- Calculating date differences by year, month, day, and more.srt
│ └─◇ 0403 WEEKDAY- Determining the day of the week.srt
│ └─◇ 0404 NETWORKDAYS- Calculating working days.srt
│ └─◇ 0405 WORKDAY- Calculating an ending date.srt
│ └─◇ 0406 DATEVALUE and TIMEVALUE- Converting text entries into dates and times.srt
├─◆5. Calculating with Dates and Times
│ └─◇ 0501 Calculating date differences across days, months, and years.srt
│ └─◇ 0502 Calculating time differences within and across days.srt
│ └─◇ 0503 Calculating fiscal years and quarters.srt
│ └─◇ 0504 Rounding time calculations to convenient intervals.srt
│ └─◇ 0505 Using times with currency calculations.srt
│ └─◇ 0506 Calculating holidays (Labor Day, Thanksgiving, Memorial Day, etc.).srt
├─◆6. Using Dates and Times with Excel Commands
│ └─◇ 0601 Using special date filters with date data.srt
│ └─◇ 0602 Using date controls in data validation rules.srt
│ └─◇ 0603 Using date functions in data validation rules.srt
│ └─◇ 0604 Converting unusually formatted dates into usable data (text to columns).srt
├─◆Conclusion
│ └─◇ Goodbye.srt

【本字幕由ACELY.CN独家制作发布】


┃本套教程字幕包含中文字幕
┃中文字幕使用机器翻译,对翻译结果中不当内容不承担任何责任!
┃更多中文字幕请访问唯一发布站【ACELY.CN】
┃本站中文字幕未经允许一律严禁转载!


>>>>>>>【点我下载】<<<<<<<

标签:, ,

您的留言是我最大的支持!

你必须登录才能发表评论!

※ 本站内容未经允许一律严禁转载!Lynda教程及字幕交流群:214645753
※ 本站文件统一解压密码:acely.cn 或 www.cgsub.com