PivotTable is an extremely powerful tool that you can use to spce 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.

Audience

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 highpght a trend, these tables help your audience “see” what you are talking about.

Prerequisites

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.