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