Lynda com Excel 2010 Working with Dates and Times | 0D2BF552EF1BAB60201A72039151E8A2D25AB4C3

Lynda com Excel 2010 Working with Dates and Times

Name	Lynda.com Excel 2010 Working with Dates and Times	DOWNLOAD Copy Link
Total Size	109.5 MB
Total Files	54
Hash	0D2BF552EF1BAB60201A72039151E8A2D25AB4C3

/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/Chapter01/
02_BusinessData.xlsx	135.5 KB
01_BusinessData.xlsx	135.5 KB
/Exercise Files/Chapter02/
04_BusinessData.xlsx	137.5 KB
01_BusinessData.xlsx	135.4 KB
02_BusinessData.xlsx	135.3 KB
03_BusinessData.xlsx	135.3 KB
/Exercise Files/Chapter03/
02_BusinessData.xlsx	140.5 KB
03_BusinessData.xlsx	140.4 KB
01_BusinessData.xlsx	135.3 KB
/Exercise Files/Chapter04/
06_BusinessData.xlsx	161.1 KB
01_BusinessData.xlsx	140.2 KB
03_BusinessData.xlsx	139.2 KB
02_BusinessData.xlsx	137.2 KB
04_BusinessData.xlsx	136.4 KB
05_BusinessData.xlsx	136.4 KB
/Exercise Files/Chapter05/
05_BusinessData.xlsx	161.2 KB
06_BusinessData.xlsx	160.7 KB
04_BusinessData.xlsx	160.6 KB
03_BusinessData.xlsx	154.9 KB
01_BusinessData.xlsx	154.8 KB
02_BusinessData.xlsx	148.2 KB
/Exercise Files/Chapter06/
02_BusinessData.xlsx	151.2 KB
03_BusinessData.xlsx	149.8 KB
04_BusinessData.xlsx	149.1 KB
01_BusinessData.xlsx	147.9 KB
/
quasar.nfo	3.3 KB
Total files 54