Have a Question? Call (646) 412 3370 or Click here to email us.
Cart 0
Excel 2013 Pivot Tables Online Training Course

Excel 2013 Pivot Tables Online Training Course

[ TTEX2013PT ]


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

Course Description

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.

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.

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

  • Length of Subscription: 12 Months Online On-Demand Access
  • Running Time: 5 hours 4 min
  • 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