Productivity & Collaboration Tools     Microsoft Office 2016     Excel 2016     Microsoft Office 2016: Intermediate Excel

---

Excel 2016 includes a number of methods for locating and displaying only certain entries. Learn how to work with specific data using the Find and Replace tools, sorting and filtering, hiding duplicates, and grouping.

---

---

Objectives
Excel 2016: Finding, Sorting & Filtering Data Using the Find tool Using the Replace tool Using the Find & Replace tools in a formula Sorting your data Filtering your data Sorting & filtering using colors Using slicers in tables Using the advanced filter options Hiding duplicate values Freezing & unfreezing panes Grouping items & creating an outline