SkillSoft Explore Course – Lambers, Inc.

BUY NOW! STARTING AT ONLY $299!

Productivity & Collaboration Tools Microsoft Office 2010 Microsoft Office 2010: Intermediate Excel (No Assessments)

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.

Asset ID	ds_msex2010_07_enus
Course Type	Video Course
Course Category	Microsoft Office 2010

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