Microsoft Excel 2016 Pivot Tables Essentials Workshop Manual

About this manual

This manual provides step-by-step instructions for using Pivot Tables in Microsoft Excel 2016. It covers creating Pivot Tables, applying filters and slicers, generating Pivot Charts, managing totals, grouping data, conditional formatting, and creating macros. The guide uses a sample dataset to demonstrate practical applications for summarizing and analyzing spreadsheet data.

The manual is designed for users who want to understand how to manipulate and report on large datasets efficiently using Excel’s Pivot Table features.

What's inside

• Create a PivotTable
• Update PivotTable Data
• Pivoting Data
• Add Columns
• Filters
• Slicers
• Pivot Charts
• Connect to External Data Source
• Create Recommended PivotTable
• Manage Subtotals and Grand Totals

Frequently asked questions

How do I create a PivotChart?

After creating a PivotTable, click the PivotTable Tools > Analyze tab, then click PivotChart to generate a chart based on your PivotTable data.

What is the purpose of Pivot Tables in Excel?

Pivot Tables are interactive tables that allow you to manage and summarize substantial amounts of data in a concise format for easy reporting and analysis.

How do you update a PivotTable after changing source data?

To update the data, select any cell on the PivotTable and then click the Refresh button on the Analyze tab.

What is the name of the practice file used in the exercises?

The exercises use a file named Excel2016_Pivot_Practice.xlsx.