Lynda - Excel 2010: Working with Dates and Times

MP4 | Video: 960x540 | 127 kbps | 48 KHz | Duration: 1h 20m | 205 MB

Genre: eLearning | Language: English

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