Lynda - Excel 2013 Managing And Analyzing Data

File Name

Size

0. Introduction/01. Welcome.mp4

7.9 MB

0. Introduction/02. Using the exercise files.mp4

1.5 MB

1. Sorting Data/01. Sorting concepts and Sort dialog options.mp4

31 MB

1. Sorting Data/02. Sorting from menu icons.mp4

13 MB

1. Sorting Data/03. Multiple-key sorting.mp4

17 MB

1. Sorting Data/04. Sorting based on the order of data in custom lists.mp4

19 MB

1. Sorting Data/05. Sorting by color font, color background, or icon.mp4

24 MB

1. Sorting Data/06. Sorting columns from left to right.mp4

12 MB

1. Sorting Data/07. Sorting data in random order.mp4

7.5 MB

2. Filtering Data/01. Single- and multiple-column text filtering.mp4

14 MB

2. Filtering Data/02. Using text filters.mp4

18 MB

2. Filtering Data/03. Using date filters.mp4

15 MB

2. Filtering Data/04. Using numeric filters.mp4

6.5 MB

2. Filtering Data/05. Using the Top 10 (value or percent) option.mp4

10 MB

2. Filtering Data/06. Creating custom filters.mp4

14 MB

2. Filtering Data/07. Copying and sorting filtered lists.mp4

13 MB

2. Filtering Data/08. Recognizing the limitations of standard filtering.mp4

13 MB

3. Advanced Filter/01. Using Advanced Filter for complex OR criteria.mp4

33 MB

3. Advanced Filter/02. Using Advanced Filter for specialized filters.mp4

15 MB

3. Advanced Filter/03. Using Advanced Filter to create unique lists from repeating field data.mp4

10 MB

4. Creating Automatic Subtotals in Sorted Lists/01. Setting up single- and multiple-level subtotals.mp4

25 MB

4. Creating Automatic Subtotals in Sorted Lists/02. Expand and collapse displays quickly with grouping and outlining symbols.mp4

39 MB

5. Eliminate Duplicate Data/01. Using the Remove Duplicates command.mp4

13 MB

5. Eliminate Duplicate Data/02. Using a specialized array formula to identify data that's been duplicated.mp4

17 MB

5. Eliminate Duplicate Data/03. Using an array formula to count the number of unique items in a list.mp4

13 MB

6. Data Analysis Tools/01. Using SUMIF, COUNTIF, and related functions for quick data analysis.mp4

26 MB

6. Data Analysis Tools/02. Using database functions_ DSUM, DAVERAGE, DMAX, and more.mp4

10 MB

6. Data Analysis Tools/03. Converting lists to tables.mp4

48 MB

7. Conclusion/01. Next steps.mp4

1.4 MB

Exercise Files/CH_01.xlsx

659 kB

Exercise Files/CH_02.xlsx

1015 kB

Exercise Files/CH_03.xlsx

235 kB

Exercise Files/CH_04.xlsx

162 kB

Exercise Files/CH_05.xlsx

341 kB

Exercise Files/CH_06.xlsx

280 kB