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.
Play course overview
Course info
Rating
(149)
Level
Intermediate
Updated
Feb 12, 2016
Duration
2h 24m
Table of contents
Course Overview
Course Overview 2m
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
Introduction 1m Creating a Summary Block 6m Creating a Pivot Line Chart 2m Creating a Sparkline Chart 4m Creating a Line Chart with Additional Data 6m Adding a Slicer 6m Course Summary 1m
Description
Course info
Rating
(149)
Level
Intermediate
Updated
Feb 12, 2016
Duration
2h 24m
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
Mike Thomas
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.

More from the author
Working with Excel on the iPad
Beginner
2h 7m
Dec 9, 2015
Getting Started with Excel 2016 for Mac
Beginner
2h 25m
Oct 7, 2015
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Mike Thomas and welcome to my course Pivot Tables for Excel 2016. I'm an IT trainer with over 27 years' experience. 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. In this course, you'll learn how to create and manipulate pivot tables and get answers to those important questions on which you base your key business decisions. Some of the major topics that we'll cover include best practice guidelines for setting up your data sources, formatting a pivot table to make it understandable and inviting to read, producing powerful reports, including sorting, filtering, and grouping your data, presenting your data as a chart and an infographic, and how to create a pivot table driven dashboard. By the end of the course, you'll have a solid foundation that you can use to build your own pivot tables and reports. And as long as you can create basic worksheets, understand simple formula, and copy and paste, and apply basic formatting to cells, you'll be able to follow along. So I hope you'll join me on this journey to learn pivot tables with the Pivot Tables for Excel 2016 course at Pluralsight.

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT