Overview
-
Learn easy-to-use data management commands and techniques to manage and analyze large lists of data.
Syllabus
-
Introduction
- Welcome
- Sort concepts and Sort menu options
- Multiple-key sorting
- Sort from AZ and ZA menu icons
- Sort based on data order in custom lists
- Sort by background color or font color
- Sort left-to-right columns
- Sort data in random order
- Filter single- and multiple-column text
- Numeric filters
- Date filters
- Text filters
- Top 10 (value or percent) option
- Create custom filters
- Copy and sort filtered lists
- Recognize standard filtering limitations
- Advanced Filter for complex OR criteria
- Advanced Filter for specialized filters
- Advanced Filter to create unique lists
- Single- and multiple-level subtotals
- Expand and collapse displays with symbols
- Remove Duplicates command
- Identify duplicate data
- Count unique items using an array formula
- SUMIF and COUNTIF and related functions
- Database functions
- Use tables for formatting and data-handling features
- Next steps
