Excel 2016 PivotTables and PivotCharts


Pivot tables are used to quickly synthesize a set of information.

To synthesize this data, you will define a PivotTable. Select a cell in the range. Switch to the Insert tab in the ribbon, and then click the PivotTable icon in the Tables group. This action displays the Create PivotTable dialog box. All data on the sheet is automatically selected. Choose where to create the PivotTable, and then click OK.

Table of Contents

  • PivotTables and PivotCharts – Multiple Sheets
  • PivotTable/PivotChart Wizard
  • Add fields to the PivotTable/PivotChart
  • Change the field grouping
  • Change the sub-field grouping
  • Change the visible rows
File Size:
304.87 Kb
Submitted On:

Take advantage of this course called Excel 2016 PivotTables and PivotCharts to improve your Office skills and better understand Excel 2016.

This course is adapted to your level as well as all Excel 2016 pdf courses to better enrich your knowledge.

All you need to do is download the training document, open it and start learning Excel 2016 for free.

Download File

Microsoft Excel 2016 Course for Beginners

Looking for Excel 2016 tutorials? this page is a free training document of Excel 2016 courses, in pdf.


Introduction to Microsoft Publisher

Download Introduction to Microsoft Publisher in PDF, free training document about how to create a perform basic tasks and creating business and greeting card.


Microsoft Excel 2007 Advanced - Tutorial

Download free Microsoft Excel 2007 Advanced course material and training, a 100 pages pdf documents intended to beginners.


Excel 2016 Math with Dates and Times

With this tutorial, you will learn a lot of shortcuts and custom formatting options about Dates and Times in Excel 2016. Training documents courses on 17 pages for beginners.


Excel 2016 Shortcuts

With this reference, you will learn how to use easily Microsoft Excel 2016, all keyboard shortcuts that you need to work as a professional. Free training document in pdf designated to beginners.