Lynda com Excel 2010 Working with Dates and Times | 7B3F82C1AE6B304EF469040A6DABBEACC5491A02

Lynda com Excel 2010 Working with Dates and Times

Name	Lynda.com - Excel 2010. Working with Dates and Times	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	109.2 MB
Total Files	29
Hash	7B3F82C1AE6B304EF469040A6DABBEACC5491A02

/00 Introduction/
0001 Welcome.mov	9.7 MB
0002 Using the exercise files.mov	370.9 KB
/01 Excel's Date Time Entries/
0101 Understanding how Excel records and stores dates.mov	5.2 MB
0102 Understanding how Excel records and stores times.mov	1.8 MB
/02 Creating Date Time Entries/
0204 Using Auto Fill to enter date and time series.mov	6.8 MB
0203 Using TODAY and NOW functions for dynamic date time entry.mov	3.3 MB
0201 Looking at standard date time entry options and acceptable alternatives.mov	3.3 MB
0202 Using instant date time entry.mov	1.6 MB
/03 Date Time Formatting/
0303 Creating custom date formatting.mov	3.0 MB
0302 Formatting time for hours over 24.mov	2.6 MB
0301 Exploring keystroke shortcuts.mov	2.4 MB
/04 Excel's Date Time Functions/
0401 EOMONTH and EDATE Setting ends of months and future past dates.mov	5.1 MB
0402 DATEDIF Calculating date differences by year, month, day, and more.mov	5.0 MB
0406 DATEVALUE and TIMEVALUE Converting text entries into dates and times.mov	3.5 MB
0404 NETWORKDAYS Calculating working days.mov	2.7 MB
0405 WORKDAY Calculating an ending date.mov	2.1 MB
0403 WEEKDAY Determining the day of the week.mov	2.1 MB
/05 Calculating with Dates and Times/
0503 Calculating fiscal years and quarters.mov	6.6 MB
0502 Calculating time differences within and across days.mov	6.1 MB
0504 Rounding time calculations to convenient intervals.mov	5.7 MB
0505 Using times with currency calculations.mov	3.0 MB
0501 Calculating date differences across days, months, and years.mov	2.1 MB
0506 Calculating holidays (Labor Day, Thanksgiving, Memorial Day, etc.).mov	2.1 MB
/06 Using Dates and Times with Excel Commands/
0602 Using date controls in data validation rules.mov	6.6 MB
0601 Using special date filters with date data.mov	4.7 MB
0604 Converting unusually formatted dates into usable data (text to columns).mov	4.5 MB
0603 Using date functions in data validation rules.mov	3.6 MB
/07 Conclusion/
0701 Goodbye.mov	275.9 KB
/Exercise Files/
Ex_Files_Excel2010_Dates.zip	3.3 MB
Total files 29