PivotTables and Advanced Charts in Excel 2016

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

0.9 hour

Lesson Objectives

- 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