Code School for Kids

Introduction to Excel Pivot Tables for Data Analysis

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.