Microsoft Office 2016 Intermediate Excel: PivotTables and Advanced Charts

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

---

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

Expertise Level
Intermediate