Pivot tables are a useful feature of MS Excel. They can be used to summarize, analyze, and present your data. In plain English, it means, you can analyze a product, take the sales data, view region and product-wise revenues with columns, and use pivot tables to find out how products are performing in each region. Once you have finished looking at the summarized data, you can quickly re-sort your data and look at it from a different perspective, all without using functions or formulas.
You’ll learn how to:
Plan your Pivot Table
Create a Pivot Table
Use a Pivot Table and its fields