New Pivot Table Style in Excel 2013

A Pivot data is used to define data in a summarized form while using the spreadsheets for data visualization. A Pivot table table can sort the data automatically; it also can give the total and count of the data stored in a table. In Excel 2013 we have a new feature for the Pivot table .i.e. recommended Pivot Tables. This feature is used to recommend which pivot table we can use in our sheet to summarize the data based on our requirements.

Let's have a look at the following steps:

Step 1

First go to Excel 2013.

Step 2

Now select Blank Workbook template from the available templates.

we1.jpg

Step 3

Now enter some data on the sheet to which we want to summarize through the pivot table.

we2.jpg

Step 4

Now select the data and click on the insert menu option like this:

we3.jpg

Step 5

Now select the Pivot Table option.

we4.jpg

Step 6

A "Create PivotTable" dialog box will appear like this:

we5.jpg

Step 7

In this just select the Existing Worksheet option and select some portion of the sheet that we want to show the data in the form of a pivot table and click on the ok button.

we6.jpg

Step 8

Now select all the fields showing in the PivotTable Fields task pane like this:

we7.jpg

Step 9

Now a pivot table will be generated like this:

we8.jpg

Step 10

Now if we want to summarize the data in a different way recommended by the pivot table then we will click on the recommended Pivot Tables option under the insert menu.

we9.jpg

Step 11

A Recommended PivotTables dialog box will appear like this:

we10.jpg

Step 12

Select any one recommended pivot table based on our requirements and click on the ok button.

we11.jpg

Step 13

A new pivot Table will appear like this:

we12.jpg

Up Next
    Ebook Download
    View all
    Learn
    View all