Microsoft Office 2016 Intermediate Excel: Working with Data

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.

Prerequisite
None

Expected Duration
65 minutes

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.

Objective

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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.