Course Details

Previous Page


Microsoft Office 2016 Intermediate Excel: PivotTables and Advanced Charts


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



Overview/Description
In Microsoft Excel 2016, PivotTables and PivotCharts let you dynamically reorganize and display your data. They can summarize huge amounts of data by category without the need to input complex formulas or spend long hours manually reorganizing your spreadsheet. You can choose and change what you want to summarize. In this course, you will also learn how to use advanced chart features like trendlines and dual axis charts.

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)
0.9

Lesson Objectives

Microsoft Office 2016 Intermediate Excel: PivotTables and Advanced Charts

  • start the course
  • create a PivotTable in Microsoft Excel 2016
  • modify the data in a PivotTable in Microsoft Excel 2016
  • alter the look of your PivotTable in Microsoft Excel 2016
  • filter PivotTable data with slicers in Microsoft Excel 2016
  • use recommended charts to create a PivotChart in Microsoft Excel 2016
  • use PivotTable data to create a PivotChart in Microsoft Excel 2016
  • alter the data in a PivotChart in Microsoft Excel 2016
  • add trendlines to a chart in Microsoft Excel 2016
  • create a dual axis chart in Microsoft Excel 2016
  • create a chart template from an existing chart in Microsoft Excel 2016
  • present data in PivotTables and PivotCharts
  • Course Number:
    mo_inel_a05_dt_enus