Desktop Certifications     Microsoft     Microsoft Office Specialist (MOS) on Microsoft Office 2016     77-727 Excel 2016: Core Data Analysis, Manipulation, and Presentation

---

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.

---

---

Objectives

PivotTables 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 PivotCharts 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 Advanced Charts 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 Practice: PivotTables and PivotCharts present data in PivotTables and PivotCharts