Excel 2010: Finding, Sorting, & Filtering Data

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.6

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