Pivot Tables for Excel 2016

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
(82)
Level
Intermediate
Updated
February 12, 2016
Duration
2h 23m
Table of contents
Description
Course info
Rating
(82)
Level
Intermediate
Updated
February 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.

More from the author
Working with Excel on the iPad
Beginner
2h 7m
9 Dec 2015
Transcript
Transcript

Hi everyone, my name is Mike Thomas and welcome to my course Pivot Tables for Excel 2016. I am an IT Trainer with over 27 years experience.

Although I cover a wide range of technologies, my passion is Excel and in 2012 I founded theexceltrainer.co.uk, through which I provide written and video based tutorials. Pivot tables are one of the most powerful tools in Excel’s data analysis armoury. With just a few clicks of the mouse, and no complicated formulas, you can quickly and easily summarize and analyse 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 will cover include:

  1. Best practice guidelines for setting up your data sources
  2. Formatting a pivot table to make it understandable and inviting to read
  3. Producing powerful reports including sorting, filtering and grouping your data
  4. Presenting your data as a chart and an infographic
  5. how to create a pivot table drive dashboard
By the end this course you’ll have a solid foundation that you can use to build your own pivot tables and reports. As long as you can create basic worksheets, understand simple formulas, and can copy and paste and apply basic formatting to cells, you’ll be able to follow along.