LcExc2013WorkingData | A6DCA00AE42F4339EB21AAB0726BE8E69E085FD4

LcExc2013WorkingData

Name	LcExc2013WorkingData	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	222.8 MB
Total Files	30
Hash	A6DCA00AE42F4339EB21AAB0726BE8E69E085FD4

/01. Introduction/
01_01-Welcome.mp4	9.0 MB
01_02-Using the exercise files.mp4	1.5 MB
/02. The Excel Date and Time Systems/
02_01-How Excel records and stores dates.mp4	13.9 MB
02_02-How Excel records and stores times.mp4	4.5 MB
/03. Creating Date and Time Entries/
03_01-Standard date- and time-entry options and acceptable alternatives.mp4	10.5 MB
03_02-Instant date and time entry.mp4	2.4 MB
03_03-Using TODAY and NOW functions for dynamic date and time entry.mp4	5.2 MB
03_04-Using AutoFill to enter a date or time series rapidly.mp4	18.9 MB
/04. Date and Time Formatting/
04_01-Standard date and time formats.mp4	7.6 MB
04_02-Custom date formatting.mp4	7.0 MB
04_03-Keystroke shortcuts.mp4	5.4 MB
04_04-Time formatting for hours over 24.mp4	6.9 MB
/05. Date and Time Functions/
05_01-EOMONTH and EDATE End of months and futurepast dates.mp4	9.5 MB
05_02-DATEDIF Date differences by year, month, day, and more.mp4	15.6 MB
05_03-WEEKDAY Day-of-week determination.mp4	2.8 MB
05_04-Calculating week numbers with WEEKNUM and ISOWEEKNUM.mp4	5.4 MB
05_05-NETWORKDAYS Calculate working days.mp4	5.5 MB
05_06-WORKDAY Calculate ending date.mp4	5.8 MB
05_07-DATEVALUE and TIMEVALUE Convert text entries into dates and times.mp4	4.8 MB
/06. Calculating with Dates and Times/
06_01-Calculating date differences with formulas and the DAYS function.mp4	4.0 MB
06_02-Calculating time differences within and between days.mp4	5.7 MB
06_03-Calculating fiscal years and quarters.mp4	9.3 MB
06_04-Calculating the first or last day of the last, current, or future month.mp4	7.4 MB
06_05-Calculating holidays (Labor Day, Thanksgiving, Memorial Day, etc.).mp4	7.6 MB
06_06-Rounding time calculations to convenient intervals.mp4	9.8 MB
06_07-Using times with currency calculations.mp4	5.7 MB
/07. Using Dates and Times with Excel Commands/
07_01-Using special date filters with date data Advanced data filter applications.mp4	13.8 MB
07_02-Using date and time controls and functions in data validation rules.mp4	10.2 MB
07_03-Converting unusually formatted dates into usable data Text to columns.mp4	5.5 MB
/08. Conclusion/
08_01-Next steps.mp4	1.6 MB
Total files 30