Lynda.com Excel 2010 Working with Dates and Times

seeders: 10
leechers: 8
Download torrent
Added on February 17, 2015 by VIP-Naruin Other > Tutorials
Torrent verified.


Lynda.com Excel 2010 Working with Dates and Times (Size: 79.96 MB)
 0001 Welcome.mov9.22 MB
 0002 Using the exercise files.mov362.17 KB
 0101 Understanding how Excel records and stores dates.mov4.98 MB
 0102 Understanding how Excel records and stores times.mov1.68 MB
 0204 Using Auto Fill to enter date and time series.mov6.45 MB
 0203 Using TODAY and NOW functions for dynamic date time entry.mov3.16 MB
 0202 Using instant date time entry.mov1.56 MB
 0303 Creating custom date formatting.mov2.88 MB
 0302 Formatting time for hours over 24.mov2.44 MB
 0301 Exploring keystroke shortcuts.mov2.32 MB
 0404 NETWORKDAYS Calculating working days.mov2.54 MB
 0405 WORKDAY Calculating an ending date.mov1.99 MB
 0403 WEEKDAY Determining the day of the week.mov1.96 MB
 0503 Calculating fiscal years and quarters.mov6.26 MB
 0502 Calculating time differences within and across days.mov5.85 MB
 0504 Rounding time calculations to convenient intervals.mov5.44 MB
 0505 Using times with currency calculations.mov2.9 MB
 0602 Using date controls in data validation rules.mov6.29 MB
 0601 Using special date filters with date data.mov4.5 MB
 0603 Using date functions in data validation rules.mov3.47 MB
 0701 Goodbye.mov269.41 KB
 05_BusinessData.xlsx157.44 KB
 06_BusinessData.xlsx156.95 KB
 04_BusinessData.xlsx156.84 KB
 03_BusinessData.xlsx151.29 KB
 01_BusinessData.xlsx151.2 KB
 02_BusinessData.xlsx144.73 KB
 06_BusinessData.xlsx157.28 KB
 01_BusinessData.xlsx136.92 KB
 03_BusinessData.xlsx135.91 KB
 02_BusinessData.xlsx133.96 KB
 04_BusinessData.xlsx133.21 KB
 05_BusinessData.xlsx133.21 KB
 02_BusinessData.xlsx147.69 KB
 03_BusinessData.xlsx146.24 KB
 04_BusinessData.xlsx145.58 KB
 01_BusinessData.xlsx144.41 KB
 02_BusinessData.xlsx137.16 KB
 03_BusinessData.xlsx137.13 KB
 01_BusinessData.xlsx132.18 KB
 04_BusinessData.xlsx134.24 KB
 01_BusinessData.xlsx132.18 KB
 02_BusinessData.xlsx132.17 KB
 03_BusinessData.xlsx132.15 KB
 02_BusinessData.xlsx132.35 KB
 01_BusinessData.xlsx132.35 KB


Description

1h 20m Intermediate Jul 28, 2010

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

Software:
Excel
Author:
Dennis Taylor

Source Page


Related Torrents

torrent name size seed leech

Sharing Widget


Download torrent
79.96 MB
seeders:10
leechers:8
Lynda.com Excel 2010 Working with Dates and Times