Want to learn how to Create a PivotTable to analyze worksheet data?

Data Management Analytics with Pivot Tables

The Pivot Table provides a speedy way to summarize your data, and to analyze, compare and detect relationships in your data. This tool can sort, count, sum and compute minimum, maximum, or mean of data stored in a worksheet.

The major features of a Pivot Table are given below−

• Creating a PivotTable is extremely simple and Quick
• Enabling churning of data instantly by simple dragging of fields, sorting, filtering and different calculations on the data.
• Arriving at the suitable representation for your data as you obtain insights into it.
• Ability to generate reports on the fly.
• Producing multiple report from the same PivotTable in a matter of seconds.
• Providing interactive report to synchronize with the audience.

Insert a Pivot Table

To insert a pivot table – execute the following steps.

• Click any single cell inside data set.
• On the Insert tab, in Tables group, click PivotTable.

• Under Choose the data that you want to examine, select a table. Then Click OK.

• In Table/Range – verify the cell range.
• Under Choose where you want the PivotTable report to be placed, select New worksheet to place the PivotTable in a new or Existing worksheet and then select the location you want the PivotTable to appear.
• Then Select OK.

Building out your PivotTable

• To add a field to your PivotTable, select the field name checkbox in the PivotTables area pane.
• To move a field from one area to another, drag and drop the field to the target area.

Learn Microsoft PowerPivot Training Course In Singapore

Get the Microsoft Office certification you need. Join Inspizone training course to become PowerPivot Expert for Microsoft Excel within 2 Days.