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.


Step 3

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


Step 4

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


Step 5

Now select the Pivot Table option.


Step 6

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


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.


Step 8

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


Step 9

Now a pivot table will be generated like this:


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.


Step 11

A Recommended PivotTables dialog box will appear like this:


Step 12

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


Step 13

A new pivot Table will appear like this:


Up Next
    Ebook Download
    View all
    View all