Course details

Excel 2019 for Windows: Sorting & Filtering Data

Excel 2019 for Windows: 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 taken 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. Key concepts covered in this 10-video course include how to sort data in a worksheet according to a specific data type; how to customize sort options when sorting data in a worksheet and sort data by using multiple criteria and sort levels; and how to create and use custom sort lists to sort data. Next, learn how to use column filters to filter data in a worksheet; to use column filters to apply multiple filters to data in a worksheet; and to create filter arguments by using text and number data types. Finally, you will learn to sort and filter data by using colors applied to data; learn to use the advanced filter tools to filter and extract data; and learn to use filter tools to hide duplicate values in a data range.



Expected Duration (hours)
0.6

Lesson Objectives

Excel 2019 for Windows: 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