Lynda - Excel 2013 Managing And Analyzing Data/0. Introduction/01. Welcome.mp4 |
7.9 MB |
Lynda - Excel 2013 Managing And Analyzing Data/0. Introduction/02. Using the exercise files.mp4 |
1.5 MB |
Lynda - Excel 2013 Managing And Analyzing Data/1. Sorting Data/01. Sorting concepts and Sort dialog options.mp4 |
31.4 MB |
Lynda - Excel 2013 Managing And Analyzing Data/1. Sorting Data/02. Sorting from menu icons.mp4 |
13.3 MB |
Lynda - Excel 2013 Managing And Analyzing Data/1. Sorting Data/03. Multiple-key sorting.mp4 |
17.4 MB |
Lynda - Excel 2013 Managing And Analyzing Data/1. Sorting Data/04. Sorting based on the order of data in custom lists.mp4 |
18.6 MB |
Lynda - Excel 2013 Managing And Analyzing Data/1. Sorting Data/05. Sorting by color font, color background, or icon.mp4 |
24.3 MB |
Lynda - Excel 2013 Managing And Analyzing Data/1. Sorting Data/06. Sorting columns from left to right.mp4 |
11.6 MB |
Lynda - Excel 2013 Managing And Analyzing Data/1. Sorting Data/07. Sorting data in random order.mp4 |
7.5 MB |
Lynda - Excel 2013 Managing And Analyzing Data/2. Filtering Data/01. Single- and multiple-column text filtering.mp4 |
14.4 MB |
Lynda - Excel 2013 Managing And Analyzing Data/2. Filtering Data/02. Using text filters.mp4 |
18 MB |
Lynda - Excel 2013 Managing And Analyzing Data/2. Filtering Data/03. Using date filters.mp4 |
14.8 MB |
Lynda - Excel 2013 Managing And Analyzing Data/2. Filtering Data/04. Using numeric filters.mp4 |
6.5 MB |
Lynda - Excel 2013 Managing And Analyzing Data/2. Filtering Data/05. Using the Top 10 (value or percent) option.mp4 |
10.4 MB |
Lynda - Excel 2013 Managing And Analyzing Data/2. Filtering Data/06. Creating custom filters.mp4 |
13.8 MB |
Lynda - Excel 2013 Managing And Analyzing Data/2. Filtering Data/07. Copying and sorting filtered lists.mp4 |
12.7 MB |
Lynda - Excel 2013 Managing And Analyzing Data/2. Filtering Data/08. Recognizing the limitations of standard filtering.mp4 |
13.4 MB |
Lynda - Excel 2013 Managing And Analyzing Data/3. Advanced Filter/01. Using Advanced Filter for complex OR criteria.mp4 |
33.1 MB |
Lynda - Excel 2013 Managing And Analyzing Data/3. Advanced Filter/02. Using Advanced Filter for specialized filters.mp4 |
15 MB |
Lynda - Excel 2013 Managing And Analyzing Data/3. Advanced Filter/03. Using Advanced Filter to create unique lists from repeating field data.mp4 |
10.5 MB |
Lynda - Excel 2013 Managing And Analyzing Data/4. Creating Automatic Subtotals in Sorted Lists/01. Setting up single- and multiple-level subtotals.mp4 |
24.6 MB |
Lynda - Excel 2013 Managing And Analyzing Data/4. Creating Automatic Subtotals in Sorted Lists/02. Expand and collapse displays quickly with grouping and outlining symbols.mp4 |
38.8 MB |
Lynda - Excel 2013 Managing And Analyzing Data/5. Eliminate Duplicate Data/01. Using the Remove Duplicates command.mp4 |
12.7 MB |
Lynda - Excel 2013 Managing And Analyzing Data/5. Eliminate Duplicate Data/02. Using a specialized array formula to identify data that's been duplicated.mp4 |
17.4 MB |
Lynda - Excel 2013 Managing And Analyzing Data/5. Eliminate Duplicate Data/03. Using an array formula to count the number of unique items in a list.mp4 |
13.3 MB |
Lynda - Excel 2013 Managing And Analyzing Data/6. Data Analysis Tools/01. Using SUMIF, COUNTIF, and related functions for quick data analysis.mp4 |
25.9 MB |
Lynda - Excel 2013 Managing And Analyzing Data/6. Data Analysis Tools/02. Using database functions_ DSUM, DAVERAGE, DMAX, and more.mp4 |
10.2 MB |
Lynda - Excel 2013 Managing And Analyzing Data/6. Data Analysis Tools/03. Converting lists to tables.mp4 |
48.5 MB |
Lynda - Excel 2013 Managing And Analyzing Data/7. Conclusion/01. Next steps.mp4 |
1.4 MB |
Lynda - Excel 2013 Managing And Analyzing Data/Exercise Files/CH_01.xlsx |
659 KB |
Lynda - Excel 2013 Managing And Analyzing Data/Exercise Files/CH_02.xlsx |
1015 KB |
Lynda - Excel 2013 Managing And Analyzing Data/Exercise Files/CH_03.xlsx |
235 KB |
Lynda - Excel 2013 Managing And Analyzing Data/Exercise Files/CH_04.xlsx |
162 KB |
Lynda - Excel 2013 Managing And Analyzing Data/Exercise Files/CH_05.xlsx |
341 KB |
Lynda - Excel 2013 Managing And Analyzing Data/Exercise Files/CH_06.xlsx |
281 KB |