Have a Question? Call 0800 689 3038 or Click here to email us.
Cart 0
Excel 2016 PC : Pivot Tables Online Training Course

Excel 2016 PC : Pivot Tables Online Training Course



Seen this product cheaper elsewhere?
We'll beat any like-for-like training quote!

Course Description

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.

In this course 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.

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

Course Outline

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

  • Length of Subscription: 12 Months Online On-Demand Access
  • Running Time: 1h 3min
  • Platform:  Windows
  • Level: Beginner to Advanced
  • Project Files: Included

Learn anytime, anywhere, at home or on the go.

Stream your training via the internet, or download to your computer and supported mobile device, including iPad, iPhone, iPod Touch and most Android devices.

If you'd like a Free Demo of this product then please complete the form here :

Need to train your Team? Contact Us for Discounts on Multiple Subscription Purchases.

More from this collection