589689.xyz

Lynda - Excel 2013 Managing And Analyzing Data

  • 收录时间:2018-02-24 18:12:51
  • 文件大小:492MB
  • 下载次数:130
  • 最近下载:2020-10-03 19:31:56
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 6. Data Analysis Tools/03. Converting lists to tables.mp4 49MB
  2. 4. Creating Automatic Subtotals in Sorted Lists/02. Expand and collapse displays quickly with grouping and outlining symbols.mp4 39MB
  3. 3. Advanced Filter/01. Using Advanced Filter for complex OR criteria.mp4 33MB
  4. 1. Sorting Data/01. Sorting concepts and Sort dialog options.mp4 31MB
  5. 6. Data Analysis Tools/01. Using SUMIF, COUNTIF, and related functions for quick data analysis.mp4 26MB
  6. 4. Creating Automatic Subtotals in Sorted Lists/01. Setting up single- and multiple-level subtotals.mp4 25MB
  7. 1. Sorting Data/05. Sorting by color font, color background, or icon.mp4 24MB
  8. 1. Sorting Data/04. Sorting based on the order of data in custom lists.mp4 19MB
  9. 2. Filtering Data/02. Using text filters.mp4 18MB
  10. 5. Eliminate Duplicate Data/02. Using a specialized array formula to identify data that's been duplicated.mp4 17MB
  11. 1. Sorting Data/03. Multiple-key sorting.mp4 17MB
  12. 3. Advanced Filter/02. Using Advanced Filter for specialized filters.mp4 15MB
  13. 2. Filtering Data/03. Using date filters.mp4 15MB
  14. 2. Filtering Data/01. Single- and multiple-column text filtering.mp4 14MB
  15. 2. Filtering Data/06. Creating custom filters.mp4 14MB
  16. 2. Filtering Data/08. Recognizing the limitations of standard filtering.mp4 13MB
  17. 1. Sorting Data/02. Sorting from menu icons.mp4 13MB
  18. 5. Eliminate Duplicate Data/03. Using an array formula to count the number of unique items in a list.mp4 13MB
  19. 5. Eliminate Duplicate Data/01. Using the Remove Duplicates command.mp4 13MB
  20. 2. Filtering Data/07. Copying and sorting filtered lists.mp4 13MB
  21. 1. Sorting Data/06. Sorting columns from left to right.mp4 12MB
  22. 3. Advanced Filter/03. Using Advanced Filter to create unique lists from repeating field data.mp4 10MB
  23. 2. Filtering Data/05. Using the Top 10 (value or percent) option.mp4 10MB
  24. 6. Data Analysis Tools/02. Using database functions_ DSUM, DAVERAGE, DMAX, and more.mp4 10MB
  25. 0. Introduction/01. Welcome.mp4 8MB
  26. 1. Sorting Data/07. Sorting data in random order.mp4 8MB
  27. 2. Filtering Data/04. Using numeric filters.mp4 6MB
  28. 0. Introduction/02. Using the exercise files.mp4 2MB
  29. 7. Conclusion/01. Next steps.mp4 1MB
  30. Exercise Files/CH_02.xlsx 1015KB
  31. Exercise Files/CH_01.xlsx 659KB
  32. Exercise Files/CH_05.xlsx 341KB
  33. Exercise Files/CH_06.xlsx 281KB
  34. Exercise Files/CH_03.xlsx 235KB
  35. Exercise Files/CH_04.xlsx 162KB