Do you want to learn pivot tables? Below are five steps to start the journey!! The post has images explaining each steps and assist you in the process.
Step 1. Open the sheet that has data you want to summarize and select any cell.
Step 2. On the Insert tab, click the PivotTable button in Tables group.
Step 3. If required adjust the range of your data and provide location for pivot table. I am using default "New Worksheet" in this illustration.
Step 4. You will see your pivot table like below image. As it says "To build a report, choose fields from the PivotTable Field List" that will be your final step.
Step 5. Assign fields from PivotTable Field List to various part of table. You can do this by dragging any field name from Choose fields to add to report box and dropping it in any one of the four areas, also know as drop zones.
Keep dragging and dropping till the time you get the desired report/result. "HAPPY LEARNING"
Step 1. Open the sheet that has data you want to summarize and select any cell.
Step 2. On the Insert tab, click the PivotTable button in Tables group.
Step 3. If required adjust the range of your data and provide location for pivot table. I am using default "New Worksheet" in this illustration.
Step 4. You will see your pivot table like below image. As it says "To build a report, choose fields from the PivotTable Field List" that will be your final step.
Step 5. Assign fields from PivotTable Field List to various part of table. You can do this by dragging any field name from Choose fields to add to report box and dropping it in any one of the four areas, also know as drop zones.
Keep dragging and dropping till the time you get the desired report/result. "HAPPY LEARNING"
No comments:
Post a Comment