TechSpace Knowledgebase
Search:     Advanced search
Browse by category:
Contact Us

How to insert a Pivot Table

Views: 944
Votes: 1
Posted: 12 May, 2016
Updated: 13 May, 2016

How to insert a Pivot Table

To insert a pivot table, execute the following steps.

1. Click any single cell inside the data set.

2. On the Insert tab, click PivotTable.

Insert Excel Pivot Table

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

3. Click OK.

Create PivotTable Dialog Box

Drag fields

The PivotTable field list appears. To get the total amount exported of each product, drag the following fields to the different areas.

1. Product Field to the Row Labels area.

2. Amount Field to the Values area.

3. Country Field to the Report Filter area.

Drag Fields to Areas

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

Pivot Table

Others in this Category
document How to create Outlook tasks in OneNote
document How to insert online videos into OneNote 2016 for Windows
document How to add files to OneNote
document How to back up notes in OneNote 2016 for Windows
document How to change the default storage location for backup fileson OneNote 2007
document Manually remove a Click-to-Run installation of Office
document Install or reinstall Office from My Office Account
document Repair Outlook Data Files (.pst and .ost)
document Re-create an offline Outlook Data File (.ost)
document How to to Turn Off Windows Update in Windows 10
document Make Windows 10 notify you before downloading or installing Windows Updates
document Change Window 7 and Window 10 Password Without Knowing old Password from Command Prompt
document How to Password Protect OneNote Notebooks and Sections
document How to Recover an Unsaved Microsoft Office File
document How to Use Simple IF Statements in Excel