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

---

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.

---

---

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