Lynda - Excel 2013: Working with Dates and Times

1. 03. Creating Date and Time Entries/03_04-Using AutoFill to enter a date or time series rapidly.mp418MB
2. 05. Date and Time Functions/05_02-DATEDIF Date differences by year, month, day, and more.mp414.85MB
3. 02. The Excel Date and Time Systems/02_01-How Excel records and stores dates.mp413.23MB
4. 07. Using Dates and Times with Excel Commands/07_01-Using special date filters with date data Advanced data filter applications.mp413.17MB
5. 03. Creating Date and Time Entries/03_01-Standard date- and time-entry options and acceptable alternatives.mp49.98MB
6. 07. Using Dates and Times with Excel Commands/07_02-Using date and time controls and functions in data validation rules.mp49.75MB
7. 06. Calculating with Dates and Times/06_06-Rounding time calculations to convenient intervals.mp49.35MB
8. 05. Date and Time Functions/05_01-EOMONTH and EDATE End of months and futurepast dates.mp49.11MB
9. 06. Calculating with Dates and Times/06_03-Calculating fiscal years and quarters.mp48.91MB
10. 01. Introduction/01_01-Welcome.mp48.58MB
11. 06. Calculating with Dates and Times/06_05-Calculating holidays (Labor Day, Thanksgiving, Memorial Day, etc.).mp47.27MB
12. 04. Date and Time Formatting/04_01-Standard date and time formats.mp47.27MB
13. 06. Calculating with Dates and Times/06_04-Calculating the first or last day of the last, current, or future month.mp47.1MB
14. 04. Date and Time Formatting/04_02-Custom date formatting.mp46.67MB
15. 04. Date and Time Formatting/04_04-Time formatting for hours over 24.mp46.57MB
16. 05. Date and Time Functions/05_06-WORKDAY Calculate ending date.mp45.5MB
17. 06. Calculating with Dates and Times/06_07-Using times with currency calculations.mp45.46MB
18. 06. Calculating with Dates and Times/06_02-Calculating time differences within and between days.mp45.41MB
19. 07. Using Dates and Times with Excel Commands/07_03-Converting unusually formatted dates into usable data Text to columns.mp45.25MB
20. 05. Date and Time Functions/05_05-NETWORKDAYS Calculate working days.mp45.23MB
21. 04. Date and Time Formatting/04_03-Keystroke shortcuts.mp45.18MB
22. 05. Date and Time Functions/05_04-Calculating week numbers with WEEKNUM and ISOWEEKNUM.mp45.11MB
23. 03. Creating Date and Time Entries/03_03-Using TODAY and NOW functions for dynamic date and time entry.mp44.99MB
24. 05. Date and Time Functions/05_07-DATEVALUE and TIMEVALUE Convert text entries into dates and times.mp44.54MB
25. 02. The Excel Date and Time Systems/02_02-How Excel records and stores times.mp44.3MB
26. 06. Calculating with Dates and Times/06_01-Calculating date differences with formulas and the DAYS function.mp43.77MB
27. 05. Date and Time Functions/05_03-WEEKDAY Day-of-week determination.mp42.63MB
28. 03. Creating Date and Time Entries/03_02-Instant date and time entry.mp42.32MB
29. 08. Conclusion/08_01-Next steps.mp41.57MB
30. 01. Introduction/01_02-Using the exercise files.mp41.42MB