Section 1 : Introduction
|
Lecture 1 | Become efficient and effective with your data in Excel | 00:00:42 Duration |
Section 2 : Data Preparation
|
Lecture 1 | Structure data for optimum usage in Excel | 00:04:54 Duration |
|
Lecture 2 | Convert lists to tables | 00:06:24 Duration |
|
Lecture 3 | Use formulas in tables | 00:07:03 Duration |
Section 3 : Sort Data
|
Lecture 1 | Sort concepts and Sort menu options | 00:03:59 Duration |
|
Lecture 2 | Multiple-key sorting | 00:04:30 Duration |
|
Lecture 3 | Sort from menu icons | 00:04:24 Duration |
|
Lecture 4 | Sort based on the order of data in custom lists | 00:05:31 Duration |
|
Lecture 5 | Sort by cell color, font color, or cell icon | 00:05:24 Duration |
|
Lecture 6 | Sort columns | 00:02:29 Duration |
|
Lecture 7 | Sort data in random order | 00:02:34 Duration |
Section 4 : Create Automatic Subtotals in Sorted Lists
|
Lecture 1 | Set up single- and multiple-level subtotals | 00:04:57 Duration |
|
Lecture 2 | Expand and collapse displays quickly with grouping and outlining symbols | 00:05:57 Duration |
Section 5 : Filter Data
|
Lecture 1 | Filter single and multiple columns | 00:04:29 Duration |
|
Lecture 2 | Text filters | 00:03:26 Duration |
|
Lecture 3 | Date filters | 00:03:36 Duration |
|
Lecture 4 | Numeric filters | |
|
Lecture 5 | Top ten (value or percent) option | 00:04:35 Duration |
|
Lecture 6 | Custom filters and wildcards ( and ) | 00:06:46 Duration |
|
Lecture 7 | Copy and print filtered lists | 00:04:16 Duration |
|
Lecture 8 | Recognize the limitations of standard filtering | 00:03:18 Duration |
|
Lecture 9 | Filter table data interactively using slicers |
Section 6 : Advanced Filtering Tools
|
Lecture 1 | Advanced Filter for complex OR criteria | 00:06:01 Duration |
|
Lecture 2 | Advanced Filter for specialized filters | 00:04:51 Duration |
|
Lecture 3 | Advanced Filter to create unique lists from repeating field data | 00:03:49 Duration |
|
Lecture 4 | Add the AutoFilter button for selection filtering | 00:02:34 Duration |
Section 7 : Eliminate Duplicate Data
|
Lecture 1 | Remove Duplicates command | 00:03:26 Duration |
|
Lecture 2 | Use formulas to identify duplicate data and number of unique entries | |
|
Lecture 3 | Use new Excel functions to count unique entries and create unique lists | 00:05:04 Duration |
Section 8 : Data Analysis Tools
|
Lecture 1 | SUMIF, COUNTIF, and related functions for quick data analysis | |
|
Lecture 2 | Explore more database functions | 00:05:03 Duration |
|
Lecture 3 | Use the AGGREGATE function to bypass errors and hidden rows |