Excel 2016 for PC – Pivot Tables


This Excel 2016 for PC – Pivot Tables online training series explores Excel® 2016 Pivot Tables – dynamic worksheets that can be reorganized by the user, with data generated from a database or a table.

Length: 1 hr 3 min

This title is available in the
Total Training All-Access library.

Subscribe Now


In this Excel 2016 for PC – Pivot Tables online training series hosted by Dan Fanella, PhD, you’ll learn how to develop a whole new appreciation for the information in your spreadsheets and gain insights into what it might mean. You’ll also learn how to create Pivot Charts, Sparklines and other elements to better visually represent your data.

Sample clip

A. Getting Started
What you’ll learn in this training
What is a Pivot Table?
Selecting appropriate data for a Pivot Table

B. Creating & Deleting
Creating a Pivot Table
Selecting various data sources
Quick Analysis Tool
Recommended Pivot Table feature
Classic Pivot Table layout in the grid
Select different source data
Delete a Pivot Table

C. Custom Appearance & Layout
Add and remove field from a pivot table
Add and use the page field
Change the data area number format
Change how empty cells are displayed
Format a Pivot Table
Sort a Pivot Table
View data detail for an item
View detail for a data cell
Exclude row or column items from the data summary
Group Pivot Table by dates

D. Printing Options & Copying a Pivot Table
Printing a Pivot Table with column and row field
Insert page breaks after each row item
Copy a Pivot Table

E. Summarizing with Totals & Formulas
Display grand totals
Change the data summary function
Create a calculated field
Insert a calculated item
List the formulas used in a Pivot Table

F. Refreshing Data
Refreshing Pivot Table data
Refreshing data at specific time intervals

G. Pivot Charts
Create a Pivot Chart from an existing table
Create a Pivot Chart from scratch
Change the layout of a Pivot Chart
Convert a Pivot chart to a static chart

H. Sparklines & Slicers
Use sparklines and slicers
Create sparklines
Change the sparkline type
Format sparklines
View the parts of a slicer
Create a slicer
Format a slicer