589689.xyz

Lynda - Excel 2013: Working with Dates and Times

  • 收录时间:2018-02-26 10:38:42
  • 文件大小:212MB
  • 下载次数:39
  • 最近下载:2020-09-27 14:55:49
  • 磁力链接:
立即下载 复制链接

文件列表

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