Code. Models. Analysis. Decisions.

Introduction to Excel Pivot Tables for Data Analysis

For Excel Versions:Excel Office 365, Excel Office 365 for Mac, Excel 2016, Excel 2016 for Mac, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2008 for Mac, Excel 2007, Excel Online

This tutorial demonstrates how to use the pivot table feature in Excel, the cornerstone of any Excel analytics project. This is an introductory tutorial suitable as an overview to the subject matter.

What is a Pivot Table

Excel Pivot Tables are a powerful data aggregation and analysis tool that allow complex summarization and organization of data with little effort. In addition to summarizing large tables of data, the pivot table feature also also for visualization of data with pivot charts.

Pivot Table Tutorial

  • Use common pivot table functions such as count, sum, average
  • Insert pivot tables
  • Create pivot tables
  • Group pivot table data
  • Use pivot table filters

To follow along, download the Excel file used.