Course details

Excel Office 365 (Windows): Sorting & Filtering Data

Excel Office 365 (Windows): Sorting & Filtering Data


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

This 10-video course offers learners an in-depth exploration of Excel's sorting and filtering tools used to analyze data in a spreadsheet. You will learn how to control what is displayed in a data range, and how the values are organized in a worksheet. This course then demonstrates how to sort a data range by alphabetical order, and in value ranges. Learn how to include or exclude a header, and change the sort orientation from vertical to horizontal. Then learn how to create multiple sort levels to change how data are presented. You will learn how to create a custom sort list, and how to use column filters to show or hide different data values in your data range. You will learn to filter the data of a range and show values to meet specified criteria. This course demonstrates how to apply color coding to data items in a table, and how to use these codes to sort and filter data. Finally, learners observe how to create advanced filter criteria by using a separate table.



Expected Duration (hours)
0.7

Lesson Objectives

Excel Office 365 (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_msex365_10_enus

    Expertise Level
    Intermediate