Excel Pivot Tables Tutorial

Excel Pivot Tables Tutorial

PivotTable is an extremely powerful tool that you can use to slice and dice data. In this tutorial, you will learn these PivotTable features in detail along with examples. By the time you complete this tutorial, you will have sufficient knowledge on PivotTable features that can get you started with exploring, analyzing, and reporting data based on the requirements.

This guide targets professional who have to track and analyze hundreds of thousands of data points with a compact table.

This guide targets people who want to use tables or charts in presentations and help people understand data quickly. Whether you want to make a comparison, show a relationship, or highlight a trend, these tables help your audience “see” what you are talking about.

Before you proceed with this tutorial, we are assuming that you are already aware of the basics of Microsoft Excel basics. If you are not well aware of these concepts, then we will suggest you to go through our short tutorials on Excel.

Table of Contents:

Excel Pivot Tables - Overview
Excel Pivot Tables - Creation
Excel Pivot Tables - Fields
Excel Pivot Tables - Areas
Excel Pivot Tables - Exploring Data
Excel Pivot Tables - Sorting Data
Excel Pivot Tables - Filtering Data
Filtering data using Slicers
Excel Pivot Tables - Nesting
Excel Pivot Tables - Tools
Excel Pivot Tables - Summarizing Values
Excel Pivot Tables - Updating Data
Excel Pivot Tables - Reports