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

---

Microsoft Excel 2016 gives you a number of options for sorting and organizing data. In this course, you will learn about basic alphabetical and numerical sorts through color sorting and custom configured sorts. The course also covers grouping, filtering, searching, and ensuring valid data is entered.

---

---

Objectives

Sorting Data start the course sort data alphabetically and numerically in Microsoft Excel 2016 sort data by cell or font color in Microsoft Excel 2016 configure a custom sort in Microsoft Excel 2016 Grouping Data create data summaries using groups in Microsoft Excel 2016 calculate subtotals and grand totals in Microsoft Excel 2016 Filtering Data filter data in Microsoft Excel 2016 refine data filters in Microsoft Excel 2016 create a custom filter in Microsoft Excel 2016 Data Validation implement basic data validation in a Microsoft Excel 2016 worksheet apply advanced data validation in Microsoft Excel 2016 Searching Data search a workbook to find and replace data in Microsoft Excel 2016 Practice: Organizing Data sort, group, filter, and validate data in Microsoft Excel 2016