Microsoft Office Excel 2016 Intermediate – Working with data

Overview

Microsoft Excel 2016 gives you a number of options for sorting and organizing data. In this course, you’ll learn basic alphabetical and numeric sorting by color sorting and custom custom sorting. The course also covers grouping, filtering, searching and ensuring the entry of valid data.

Objectives

• Sort data alphabetically and numerically in Microsoft Excel 2016

• Sort data by cell color or font in Microsoft Excel 2016

• Set up custom sorting in Microsoft Excel 2016

• Create data summaries using groups in Microsoft Excel 2016

• Calculate subtotals, and of general totals in Microsoft Excel 2016

• filtering data in Microsoft Excel 2016

• refining data filters in Microsoft Excel 2016

• creating a custom filter in Microsoft Excel 2016

• implementing validation of basic data in a Microsoft Excel 2016 worksheet

• applying validation advanced data in Microsoft Excel 2016

• search a workbook to find and replace data in Microsoft Excel 2016