Excel 2013: Finding, Sorting, & Filtering Data


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description
You can easily find specific data and format how data displays in Excel 2013. Learn how to use the Find and Replace tools, sort and filter data, and hide duplicate values. Explore freezing panes, grouping items, and creating an outline.

Expected Duration (hours)
0.7

Lesson Objectives

Excel 2013: Finding, Sorting, & Filtering Data

  • Using the Find & Replace tools
  • Using the Find & Replace tools in a formula
  • Sorting your data
  • Filtering your data
  • Sorting & filtering using colors
  • Using the advanced filter options
  • Hiding duplicate values
  • Freezing & unfreezing panes
  • Grouping items & creating an outline

    • Course Number:
    ds_msex2013_08_enus

    Expertise Level
    Intermediate