Excel 2010: 日期和时间函数功能教程

:

Lynda出品的Excel 2010: Working with Dates and Times. Excel 2010: 时间和日期函数功能教程.

教程时长：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 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

截图预览:

本文链接: https://www.books51.com/29300.html

上一篇: Outlook.2007: 高效率邮件管理教程

下一篇: 从Word 2003到Word 2010

(0 次顶, 0 人已投票)
你必须注册后才能投票！

Loading...