How To Pivot Table In Excel

The pivottable field list task pane is divided into two areas.

How to pivot table in excel. Let s say you have a sales data for different regions with a pivot table you can summarize the data by region and find the average sales per region the maximum and minimum sale per region etc. The pivot table is one of microsoft excel s most powerful and intimidating functions. They can sort count and total the. Excel adds a blank grid for the new pivot table and displays a pivottable field list task pane on the right side of the worksheet area.

On the insert tab in the tables group click pivottable. The following dialog box appears. Pivot table in excel is used to categorize sort filter and summarize any length of data table which we want to get count sum values either in tabular form or in form of 2 column sets. Powerful because it can help you summarize and make sense of large data sets.

Pivot tables are interactive tables that allow the user to group and summarize large amounts of data in a concise tabular format for easier reporting and analysis. To insert the pivot table select the pivot table option from the insert menu tab which will automatically find the table or range. Intimidating because you re not exactly an excel expert and pivot tables have always had a reputation for being complicated. A pivot table is a summary of a large dataset that usually includes the total figures average minimum maximum etc.

The default location for a new pivot table is new worksheet. To insert a pivot table execute the following steps. Click any single cell inside the data set. The choose fields to add to report list box with the names of all the fields in the source data for the pivot table and an area divided into four drop zones report filter column labels row.

Excel automatically selects the data for you.