courseExcel 2016 for PC – Pivot Tables

Learn how to develop a whole new appreciation for the information in your spreadsheets with our Excel 2016 for PC - Pivot Tables course

In the duration of this course you will learn the basics and more advanced features of Pivot Tables on Microsoft Excel 2016.

What are Pivot Tables?

Pivot tables are one of Excel's most powerful features, they allow you to extract the significance from a large, detailed data set. In large sets of data, it can be hard to extract the information you want, but by building Pivot Tables you are able to ask questions and gain the information required.

Wiki_tick  Unlimited access for 60 days

Wiki_tick  Access anywhere, any time

Wiki_tick  Fast effective training, written and designed by industry experts

Wiki_tick  Track your progress with our Learning Management System

Wiki_tick  Unlimited support

Wiki_tick  Save money, time and travel costs

Wiki_tick  Learn at your own pace and leisure

Wiki_tick  Easier to retain knowledge and revise topics than traditional methods

laptop-notebook-working-internetWhat the course will teach you:

  • Select appropriate data for a Pivot Table
  • Create a Pivot Table
  • To use the Quick Analysis Tool
  • Delete a Pivot Table
  • Format a Pivot Table
  • Print a Pivot Table with column and row field
  • View and extract data from a Pivot Table

Buy Now

Units Of Study


Microsoft Excel for PC - Pivot Tables

Module 1 - Getting Started

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

Module 2 - 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

Module 3 - 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

Module 4 - 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

Module 5 - 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

Module 6 - Refreshing Data

Refreshing Pivot Table data
Refreshing data at specific time intervals

Module 7 - 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

Module 8 - 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

System Requirements

Minimum specifications for the computer are:


Microsoft Windows XP, or later
Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)


OSX/iOS 6 or later
Modern and up to date Browser (Firefox, Chrome, Safari)

All systems:

Internet bandwidth of 1Mb or faster
Flash player or a browser with HTML5 video capabilities (We recommend Google Chrome)

Please note: Although this course will work with the system requirements stated above, the software talked about and used in the course may vary. It is recommended that you check with the software suppliers website before making a purchase.