Next steps

Contents

• Introduction Introduction

  • Welcome

    55s
  • Exercise files

    22s
• 1. Data Preparation 1. Data Preparation

  • Structure data for optimum usage

    12m 2s
  • (Locked)
    Converting lists to tables

    11m 17s
  • (Locked)
    Using formulas in tables

    10m 21s
• 2. Sorting Data 2. Sorting Data

  • Sorting concepts and sort menu options

    11m 4s
  • (Locked)
    Sorting from menu icons

    7m 8s
  • (Locked)
    Multiple-key sorting

    5m 14s
  • (Locked)
    Sorting based on the order of data in custom lists

    6m 13s
  • (Locked)
    Sorting by cell color, font color, or cell icon

    4m 57s
  • (Locked)
    Sorting columns (sorting left-to-right)

    2m 25s
  • (Locked)
    Sorting data in random order

    2m 19s
• 3. Creating Automatic Subtotals in Sorted Lists 3. Creating Automatic Subtotals in Sorted Lists

  • Setting up single and multiple-level subtotals

    4m 55s
  • (Locked)
    Expanding and collapsing with grouping and outlining symbols

    7m
• 4. Filtering Data 4. Filtering Data

  • (Locked)
    Single and multiple-column filtering

    5m 19s
  • (Locked)
    Using text filters

    3m 7s
  • (Locked)
    Using date filters

    4m
  • (Locked)
    Using numeric filters

    3m 20s
  • (Locked)
    Using the Top Ten (value or percent) option

    4m 17s
  • (Locked)
    Creating custom filters

    7m 31s
  • (Locked)
    Copying and printing filtered lists

    3m 4s
  • (Locked)
    Recognizing the limitations of standard filtering

    3m 5s
  • (Locked)
    Filtering interactively using slicers with tables

    8m 36s
• 5. Advanced Filter 5. Advanced Filter

  • (Locked)
    Using Advanced Filter for complex "OR" criteria

    9m 11s
  • (Locked)
    Using Advanced Filter for specialized filters

    5m 42s
  • (Locked)
    Using Advanced Filter to create unique lists from repeating field data

    4m 15s
• 6. Eliminating Duplicate Data 6. Eliminating Duplicate Data

  • (Locked)
    Using the Remove Duplicates command

    3m 1s
  • (Locked)
    Using a specialized array formula to identify data that's been duplicated

    5m 12s
  • (Locked)
    Using an array formula to count the number of unique items in a list

    6m 36s
• 7. Data Analysis Tools 7. Data Analysis Tools

  • Using SUMIF, COUNTIF, and related functions for quick data analysis

    7m 4s
  • (Locked)
    Using database functions including DSUM, DAVERAGE, DMAX

    6m 21s
  • (Locked)
    Using the AGGREGATE function to bypass errors and hidden rows

    4m 19s
• Conclusion Conclusion

  • (Locked)
    Next steps

    23s