Excel 2013 – Pivot Tables


Presented by Robert Norgon, this online training series explores Microsoft® Excel® 2013 Pivot Tables – dynamic worksheets that can be reorganized by the user, with data generated from a database or a table.

Platform: Windows

Length: 5 hours 4 min

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

Subscribe Now


With Excel 2013 – Pivot Tables, 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.

This training course is for Microsoft Office Excel 2013 for Windows.

Sample clip

A. Getting Started
What you’ll learn in this training
Understanding the benefits of a Pivot Table
Understanding Pivot Table terminology
Selecting appropriate data for a Pivot Table

B. Creating & Deleting
Working without a Pivot Table Wizard
Using the new Quick Analysis tool
Laying out a Pivot Table manually
Using the new Recommended Pivot Table feature
Using the classic Pivot Table layout in the grid
Selecting different source data
Deleting a Pivot Table

C. Custom Appearance & Layout
Adding and removing fields from a Pivot Table
Adding and using the page field
Changing the data area number format
Changing how empty cells are displayed
Formatting a Pivot Table
Sorting a Pivot Table
Viewing data detail for an item
Viewing detail for a data cell
Excluding row or column items from the data summary
Grouping Pivot Tables by dates

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

E. Summarizing with Totals & Formulas
Displaying grand totals
Changing the Data Summary function
Creating a calculated field
Inserting a calculated item
Listing the formulas used in a Pivot Table

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

G. Pivot Charts
Creating a Pivot Chart from an existing table
Creating a Pivot Chart from scratch
Changing the layout of a Pivot Chart
Converting a Pivot Chart to a static chart

H. Sparklines and Slicers
Using Sparklines and Slicers
Creating Sparklines
Changing the Sparkline type
Formatting Sparklines
Viewing the parts of a Slicer
Creating a Slicer
Formatting a Slicer