Lynda - Excel 2010 : Working with Dates and Times

Size 109.163 MB   0 seeders     Added 2012-10-20 01:21:03

To download or stream you need BitLord. Visit them at BitLord.com
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.

[b]Topics include:[/b]
* 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
00 Introduction/0001 Welcome.mov 9.669 MB
00 Introduction/0002 Using the exercise files.mov 370.858 KB
01 Excel's Date Time Entries/0101 Understanding how Excel records and stores dates.mov 5.222 MB
Gathering some info...

Register and log in Isohunt and see no captcha anymore!

4000 symbols left
Hash 7B3F82C1AE6B304EF469040A6DABBEACC5491A02