[www.ed2k.online]下載基地為您提供軟件、遊戲、圖書、教育等各種資源的ED2K電驢共享下載和MAGNET磁力鏈接下載。
設為首頁
加入收藏
首頁 圖書資源 軟件資源 游戲資源 教育資源 其他資源
 電驢下載基地 >> 其他资源 >> 電腦基礎 >> 《Excel 2007: 日期和時間函數功能教程》(Excel 2007: Working with Dates and Times)[光盤鏡像]
《Excel 2007: 日期和時間函數功能教程》(Excel 2007: Working with Dates and Times)[光盤鏡像]
下載分級 其他资源
資源類別 電腦基礎
發布時間 2017/7/13
大       小 -
《Excel 2007: 日期和時間函數功能教程》(Excel 2007: Working with Dates and Times)[光盤鏡像] 簡介: 中文名 : Excel 2007: 日期和時間函數功能教程 英文名 : Excel 2007: Working with Dates and Times 資源格式 : 光盤鏡像 發行日期 : 2010年07月28日 地區 : 美國 對白語言 : 英語 文字語言 : 英文 簡介 : 資源簡介: Lynda出品的Excel 2007: Working with Dates
電驢資源下載/磁力鏈接資源下載:
全選
"《Excel 2007: 日期和時間函數功能教程》(Excel 2007: Working with Dates and Times)[光盤鏡像]"介紹
中文名: 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

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


相關資源:

免責聲明:本網站內容收集於互聯網,本站不承擔任何由於內容的合法性及健康性所引起的爭議和法律責任。如果侵犯了你的權益,請通知我們,我們會及時刪除相關內容,謝謝合作! 聯系信箱:ed2konline@outlook.com

Copyright © 電驢下載基地 All Rights Reserved