中文名: Excel 2007: 日期和時間函數功能教程
英文名: Excel 2007: Working with Dates and Times
資源格式: 光盤鏡像
發行日期: 2010年07月28日
地區: 美國
對白語言: 英語
文字語言: 英文
簡介:

資源簡介:
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
截圖預覽：

目錄:
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

資源來自網絡收集 未經過一一的質量 安全等檢測
只是把收集的資源和各位驢友分享 僅作網絡學習交流使用 請勿用於商業用途 !
希望各位下載的驢友能多多參與分流保源