Section 1 : Introduction

Lecture 1 Become efficient and effective with your data in Excel 0:42

Section 2 : Data Preparation

Lecture 2 Structure data for optimum usage in Excel 4:54
Lecture 3 Convert lists to tables 6:24
Lecture 4 Use formulas in tables 7:3

Section 3 : Sort Data

Lecture 5 Sort concepts and Sort menu options 3:59
Lecture 6 Multiple-key sorting 4:30
Lecture 7 Sort from menu icons 4:24
Lecture 8 Sort based on the order of data in custom lists 5:31
Lecture 9 Sort by cell color, font color, or cell icon 5:24
Lecture 10 Sort columns 2:29
Lecture 11 Sort data in random order 2:34

Section 4 : Create Automatic Subtotals in Sorted Lists

Lecture 12 Set up single- and multiple-level subtotals 4:57
Lecture 13 Expand and collapse displays quickly with grouping and outlining symbols 5:57

Section 5 : Filter Data

Lecture 14 Filter single and multiple columns 4:29
Lecture 15 Text filters 3:26
Lecture 16 Date filters 3:36
Lecture 17 Numeric filters
Lecture 18 Top ten (value or percent) option 4:35
Lecture 19 Custom filters and wildcards ( and ) 6:46
Lecture 20 Copy and print filtered lists 4:16
Lecture 21 Recognize the limitations of standard filtering 3:18
Lecture 22 Filter table data interactively using slicers

Section 6 : Advanced Filtering Tools

Lecture 23 Advanced Filter for complex OR criteria 6:1
Lecture 24 Advanced Filter for specialized filters 4:51
Lecture 25 Advanced Filter to create unique lists from repeating field data 3:49
Lecture 26 Add the AutoFilter button for selection filtering 2:34

Section 7 : Eliminate Duplicate Data

Lecture 27 Remove Duplicates command 3:26
Lecture 28 Use formulas to identify duplicate data and number of unique entries
Lecture 29 Use new Excel functions to count unique entries and create unique lists 5:4

Section 8 : Data Analysis Tools

Lecture 30 SUMIF, COUNTIF, and related functions for quick data analysis
Lecture 31 Explore more database functions 5:3
Lecture 32 Use the AGGREGATE function to bypass errors and hidden rows