Microsoft Office 2016 Intermediate Excel: Working with Data

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

Overview/Description
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.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Excel and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016.

Prerequisites
None

Expected Duration (hours)
1.1

Lesson Objectives

Microsoft Office 2016 Intermediate Excel: Working with 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

create data summaries using groups in Microsoft Excel 2016

calculate subtotals and grand totals in Microsoft Excel 2016

filter data in Microsoft Excel 2016

refine data filters in Microsoft Excel 2016

create a custom filter in Microsoft Excel 2016

implement basic data validation in a Microsoft Excel 2016 worksheet

apply advanced data validation in Microsoft Excel 2016

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

sort, group, filter, and validate data in Microsoft Excel 2016

Course Number:
mo_inel_a03_dt_enus

Expertise Level
Intermediate