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
| Size : | 304.87 Kb |
| Downloads: | 1120 |
| Created: | 2017-09-24 |
Others related eBooks about Excel 2016 PivotTables and PivotCharts
Download a basic pdf tutorial about Microsoft Excel 2016, free training document under 12 pages
Looking for Excel 2016 tutorials? this page is a free training document of Excel 2016 courses, in pdf.
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.
Quick guide to Excel 2016 intended to beginners in order to learn the fundamentals of Microsoft Excel 2016, training document in pdf.