Pivot table in Excel

MS Excel 2007: Create a pivot table

how to create a pivot table in Excel 2007 (with screenshots and step-by-step instructions.

Question: How do I create a pivot table in Microsoft Excel 2007?

Answer: In this example, the data for the pivot table resides on Sheet.

Highlight the cell where you'd like to see the pivot table. In this example, we've selected cell A1 on Sheet2.

Next, select the Insert tab from the toolbar at the top of the screen. In the Tables group, click on the arrow under the PivotTablebutton and select PivotTable from the popup menu.

A Create PivotTable window should appear. Select the range of data for the pivot table and click on the OK button. In this example, we've chosen cells A1 to D2156 in Sheet1.

Your pivot table should now appear as follows:

Next, choose the fields to add to the report. In this example, we've selected the checkboxes next to the Order ID and Quantityfields.

Next under the Values box, click on the "Sum of Order ID" and drag it to the Row Labels box.

Finally, we want the title in cell A1 to show as "Order ID" instead of "Row Labels". To do this, select cell A1 and type Order ID.

Your pivot table should now display the total quantity for each Order ID as follows:

MS Excel 2007: Change data source for a pivot table

This explains how to change the data source for a pivot table in Excel 2007 (with screenshots and step-by-step instructions

Question: In Microsoft Excel 2007, I've created a pivot table and now I need to change the data source. How do I change the data source for an existing pivot table?

Answer:Select the Options tab from the toolbar at the top of the screen. In the Data group, click on Change Data Sourcebutton.

When the Change PivotTable Data Source window appears, change the Table/Range value to reflect the new data source for your pivot table. Click on the OK button.

Now when you return to your pivot table, it should display information from the new data source.

MS Excel 2007: Refresh a pivot table

This Excel tutorial explains how to refresh a pivot table in Excel 2007 (with screenshots and step-by-step instructions.

Question: How do I refresh a pivot table in Microsoft Excel 2007?

Answer: To refresh a pivot table, right-click on the pivot table and then select "Refresh" from the popup menu.

MS Excel 2007: Remove grand totals for columns in a pivot table

This Excel tutorial explains how to remove grand totals for columns in a pivot table in Excel 2007 (with screenshots and step-by-step instructions).

Question: On a pivot table, how do I remove grand totals for columns in Microsoft Excel 2007?

Answer: Below we want to remove the grand totals for the Order ID columns.

To remove this column grand total, right-click on the pivot table and then select "PivotTable Options" from the popup menu.

When the PivotTable Options window appears, select the "Totals & Filters" tab. Then uncheck the checkbox called "Show grand totals for columns". Click the OK button.

Now when you return to the spreadsheet, the grand totals for the Order ID columns will no longer be visible.