Learn Pivot Table, Pivot Chart, Pivot Power

In this course you will learn from  experts on what a Pivot Table, Pivot Chart, Pivot Power is, find a number of examples showing how to create and use Pivot Table, Pivot Chart, Pivot Power in all version of Excel.

What is a Pivot Table in Excel?

An Excel Pivot Table is a tool to explore and summarize large amounts of data, analyze related totals and present summary reports designed to:

• Present large amounts of data in a user-friendly way.
• Summarize data by categories and subcategories.
• Filter, group, sort and conditionally format different subsets of data so that you can focus on the most relevant information.
• Rotate rows to columns or columns to rows (which is called “pivoting”) to view different summaries of the source data.
• Subtotal and aggregate numeric data in the spreadsheet.
• Expand or collapse the levels of data and drill down to see the details behind any total.
• Present concise and attractive online of your data or printed reports.

If you are working with large data sets in Excel,  Pivot Table comes in really handy as a quick way to make an interactive summary from many records. Among other things, it can automatically sort and filter different subsets of data, count totals, calculate average as well as create cross tabulations.

Another benefit of using Pivot Tables is that you can set up and change the structure of your summary table simply by dragging and dropping the source table’s columns. This rotation or pivoting gave the feature its name.