Excel 2016: Finding, Sorting & Filtering Data

Excel 2016: Finding, Sorting & Filtering Data

Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level

Overview/Description
Excel 2016 includes a number of methods for locating and displaying only certain entries. Learn how to work with specific data using the Find and Replace tools, sorting and filtering, hiding duplicates, and grouping.

Expected Duration (hours)
0.8

Lesson Objectives

Excel 2016: Finding, Sorting & Filtering Data

Using the Find tool

Using the Replace tool

Using the Find & Replace tools in a formula

Sorting your data

Filtering your data

Sorting & filtering using colors

Using slicers in tables

Using the advanced filter options

Hiding duplicate values

Freezing & unfreezing panes

Grouping items & creating an outline

Course Number:
ds_msex2016_07_enus

Expertise Level
Intermediate