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