Pivot Tables for Excel 2016
By Mike Thomas
This course is aimed at intermediate-level users of Excel 2010 and 2013 as well as 2016 for Windows and Mac who are unfamiliar with Pivot Tables and who need to summarize and analyze list-based data and make better business decisions based on that data.
Course info
Rating
Level
Intermediate
Updated
Feb 12, 2016
Duration
2h 23m
Table of contents
Course Overview
Introduction to Pivot Tables
Introduction
1m
What Is a Pivot Table?
8m
Creating a Basic Pivot Table
9m
Using an Excel Table as a Data Source
6m
Using an SQL Server Database as a Data Source
4m
Creating a Pivot Table from Multiple Tables
5m
Summary
0m
Customizations and Calculations
Introduction
1m
Summarize Using Average and Count
5m
Changing the Appearance of a Pivot Table
6m
Changing the Layout of a Pivot Table
3m
Percentages, Difference From, and Running Totals
9m
Calculations in a Pivot Table
4m
Summary
1m
Sorting, Grouping, and Filtering
Introduction
1m
Sorting a Pivot Table
4m
Filtering a Pivot Table
7m
Filtering Using Slicers
10m
Filtering Using Timeline Slicers
4m
Grouping on Dates
10m
Summary
1m
Pivot Charts and Data Visualizations
Introduction
1m
Creating a Pivot Chart
9m
Creating a Sparkline Chart
4m
Using the People Graph with a Pivot Table
3m
Summary
0m
Creating a Basic Pivot Table Driven Dashboard
Description
Course info
Rating
Level
Intermediate
Updated
Feb 12, 2016
Duration
2h 23m
Description
Pivot Tables are one of the most powerful tools in Excel's data analysis armory. With just a few clicks of the mouse (and no complicated formulas!) you can quickly and easily summarize and analyze large amounts of raw data and get answers to those important questions on which you base your key business decisions.
About the author
About the author
Based in Manchester, England, Mike has 27 years experience in corporate IT training, working with and for organizations across a diverse range of industries. He designs and delivers face-to-face, virtual, written and video-based training, primarily focusing on Microsoft Office, Lync, SharePoint, VBA development and database development.