狂人大補帖

Lynda.com Excel 2010: Working with Dates and Times 教學 英文版 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
軟體名稱: Lynda.com Excel 2010: Working with Dates and Times
語系版本: 英文版
光碟片數: 單片裝
破解說明: 無
系統支援: Windows XP/Vista/7
軟體類型: 教學
更新日期: 2010.09.10
軟體發行: lynda.com
官方網站: http://www.lynda.com/
中文網站: http://twcd01.com
軟體簡介: (以官方網站為準)
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
教程時長：1小時20分

主講： Dennis Taylor

教學光碟提供有配套練習素材.

Description：

In Excel 2010: Working with Dates and Times,
Dennis Taylor shares his solutions for optimizing the use of dates and times in Excel 2010.
This course explains whats 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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=