Course Details

Previous Page


Microsoft Office 2016 Intermediate Excel: Working with Data


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



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