Creating PivotTable

Creat a PivotTable that allows you to sort and filter only the data you need from large amounts of data.

Create PivotTable

1. Open a document you want to create a PivotTable report.
2. Select a data area and then click Data-PivotTable.
3. In the PivotTable dialog box, select the range of data to analyze. By default, the data area you have select is diaplayed in the input box.
4. Specify a location you want to insert a PivotTable. Select New Worksheet, and then name the worksheet.
5. Click OK. The new worksheet appears with the field layout entered. In the PivotTable task pane, drag the field from the Select fields to add to the report list to enter it in the area you want.
6. Once the PivotTable is created in new worksheet, change text properties or column width.

More Information

PivotTable Dialog Box

Data Range

Select the source data area from which you want to create a PivotTable.

Select Location for Inserting PivotTable

• New Worksheet

  Create a new worksheet with a PivotTable inserted. By default, the new worksheet is named “Sum 1” and can be edited.

• Existing Worksheet

  Specify a location to insert a PivotTable on the current workbook. You can enter the cell address directly, or click the area selection button  to drag the cell location to select it.