Microsoft Excel 2016 for Mac: Finding, Sorting, and Filtering Data


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

In large spreadsheets, it is not always easy to locate the data you need. Discover the tools in Excel to find, replace, sort, and filter data. Also, learn how to create an outline, freeze panes, and hide duplicate values.



Expected Duration (hours)
0.5

Lesson Objectives

Microsoft Excel 2016 for Mac: Finding, Sorting, and Filtering Data

  • Using the Find tool
  • Using the Replace tool
  • Sorting your data
  • Filtering your data
  • Sorting & filtering using colors
  • Using the advanced filter options
  • Freezing & unfreezing panes
  • Grouping items & creating an outline
  • Hiding duplicate values
  • Course Number:
    ds_msex16mc_07_enus

    Expertise Level
    Intermediate