【Lynda】Excel 2007: Working with Dates and Times【CHN】中英文字幕[SRT]
==========教程信息=====================================================
教程名称：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】
┃本站中文字幕未经允许一律严禁转载！
┗