Lynda - Excel 2013 Managing And Analyzing Data

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