How to create a PivotTable in Excel

BY Microsoft ® Excel 2007: create a PivotTable  

 

"PivotTables are a great way to summarize a large amount of data to glean from it Some Meaning. The name PivotTable Being Able to eat from the data in PivotTable pivot view. In this demonstration, you'll see how PivotTables work.

In Excel, click the Insert tab.

 

Click the PivotTable button.

Automatically selects the Entire Excel range. Howeve, You Can modify it, IF NECESSARY.

Choose where to place the PivotTable. New Worksheet is MOST common.

Click OK.

Select a field.

The PivotTable appears. Now You Need to populate it with data fields, Which Appear in the field list on the right.

Drag it onto the PivotTable grid to one of the defined areas.

Repeat the process to populate the placeholders with other data fields.

Next, let's look at Some Of The Things you can do with the data in a PivotTable.

To filter by a field, open drop-down list STIs.

Select the value by Which to filter.

Click OK.

To move a field to a different placeholder, drag it to a different section in the field list.

The table now displays the filtered data only for Criterion (in this case, the Central region).

You Might Need to resize the pane to see the field in its NEW location.

To reorder fields Within a placeholder, drag up or down Them.

To sort by a field, open drop-down list STIs.

Select one of the sort orders.

To create a chart out of the data, click the PivotChart button.

Click OK.

Select a chart type.

To see the chart more Clearly, close the task pane.

In this demonstration, you Learn how to create a PivotTable and work with the interface. Now you Understand the Benefit (and power) of this unique feature Excel."