Excel 2010: Finding, Sorting, & 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

Excel 2010: Finding, Sorting, & Filtering Data

  • Using the Find tool
  • Using the Replace tool
  • Using the Find & Replace tools in a formula
  • Sorting data in a table
  • Filtering data in a table
  • Sorting & filtering using colors
  • Using the advanced filter options
  • Hiding duplicate values
  • Freezing & unfreezing panes
  • Grouping elements & creating a plan

    • Course Number:
    ds_msex2010_07_enus

    Expertise Level
    Intermediate