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

  • use the Find tool in Excel 2016 for Mac
  • use the Replace tool in Excel 2016 for Mac
  • sort your data in Excel 2016 for Mac
  • filter your data in Excel 2016 for Mac
  • sort and filter using colors in Excel 2016 for Mac
  • use advanced filter options in Excel 2016 for Mac
  • freeze and unfreeze panes in your worksheets
  • create groups in Excel 2016 for Mac
  • hide duplicate values in Excel 2016 for Mac

    • Course Number:
    ds_msex16mc_07_enus

    Expertise Level
    Intermediate