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
Download File Size:107.29 MB