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!
