Pivot Table basics - part 2

Now that you read the basics of creating a Pivot table, the following steps will help you set up your pivot table to summarize your large amounts of data.

Reviewing the Pivot Table Fields:

• Click on the Pivot Table Field List pane on the right. 
  
  
  
  
  
  
  
• Drag fields from your data into the areas below:

Filters: Use to filter your data. 
Columns: arrange fields as column headers. 
Rows: arrange fields as row headers.
Values: summarize data like sum, average, etc.

Customizing the Pivot Table:

You can drag fields between different areas to change the layout of the Pivot Table.

you can also do a Right-click on any field to see additional options such as sorting, filtering, and summarizing.

Enjoy your data analysis in Excel!