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