Course details

Excel 2019: Sorting & Filtering Data

Excel 2019: Sorting & Filtering Data


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

The first step in analyzing the data in a worksheet is often with Excel's sorting and filtering tools. These tools help you to control what is displayed in your data range, and how the values are organized. See how to perform basic and more advanced sort operations, filter data using the Filter and column header tools, and manage color-tagged and duplicate entries.



Expected Duration (hours)
0.6

Lesson Objectives

Excel 2019: Sorting & Filtering Data

  • sort data in a worksheet according to a specific data type
  • customize sort options when sorting data in a worksheet
  • sort data using multiple criteria and sort levels
  • create and use custom sort lists to sort data
  • use column filters to filter data in a worksheet
  • use column filters to apply multiple filters to data in a worksheet
  • create filter arguments using text and number data types
  • sort and filter data using colors applied to data
  • use the advanced filter tools to filter and extract data
  • use filter tools to hide duplicate values in a data range
  • Course Number:
    ds_msex2019_10_enus

    Expertise Level
    Intermediate