Lynda com Excel 2007 Working with Dates and Times | 8C2E5FBB4B75D57280588EA321A150B281BDA6DF

Lynda com Excel 2007 Working with Dates and Times

Name	Lynda.com - Excel 2007. Working with Dates and Times	DOWNLOAD Copy Link
Total Size	115.8 MB
Total Files	29
Hash	8C2E5FBB4B75D57280588EA321A150B281BDA6DF

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