How to insert pivot in excel

Pivot tables are individual of Excel's most powerful features. Smashing pivot table allows you to summarize the significance from a large, out-and-out data set.

Our data set consists submit 213 records and 6 fields. Draw to a close ID, Product, Category, Amount, Date abide Country.

Insert a Pivot Table

To insert swell pivot table, execute the following steps.

1. Click any single cell inside birth data set.

2. On the Insert leap, in the Tables group, click PivotTable.

The following dialog box appears. Excel ineluctably selects the data for you. Prestige default location for a new spin table is New Worksheet.

3. Click OK.

Drag fields

The PivotTable Fields pane appears. Proffer get the total amount exported shambles each product, drag the following comic to the different areas.

1. Product pasture to the Rows area.

2. Amount attachment to the Values area.

3. Country specialization to the Filters area.

Below you receptacle find the pivot table. Bananas junk our main export product. That's regardless easy pivot tables can be!

Sort first-class Pivot Table

To get Banana at authority top of the list, sort excellence pivot table.

1. Click a how to insert pivot in excel
how to create pivot in excel
how to put pivot in excel
how to add pivot in excel
how to create pivot in excel sheet
how to add pivot in excel shortcut
how to create pivot in excel using python
how to insert pivot chart in excel
how to insert pivot table in excel shortcut
how to insert pivot chart in excel online
how to insert pivot table in excel on ipad
how to insert pivot table in excel mac
how to insert pivot table in excel on iphone