Recommended PivotTables in Excel 13

A PivotTable can sort our data automatically in a spreadsheet.

A PivotTable can give the total and the count of the data that is stored in a table.

A PivotTable makes our life easier.

A PivotTable! How can we be sure that we have made the most appropriate one?

This is where Excel 13 appears, with its new feature named Recommended Pivot Tables.

This new feature recommends which PivotTable we can use in our spreadsheet in order to summarize out data.

Let’s see how it works!!!

First of all we must select our data in the spreadsheet or just click in one cell that contains data and we want to represent them with a PivotTable. Then we must select the tab Insert and from the left area of the ribbon named Tables we select the command Recommended PivotTables as we can see in the image below.

Recommended PivotTables


Once the command is selected the Recommended PivotTables dialog box appears as we can see below. The dialog box differs depending on the sort of data that we have in our spreadsheet. In my example according to the data that I have inputted in the spreadsheet, we see that the first Recommended PivotTable is Sum of Total by Company.

Recommended - Sum

The second Recommended Pivot Table is the Sum of Amount by Company.


The third Recommended PivotTable is the Sum of FPA, Sum of Amount and Count of Code Number by Company.


The fourth Recommended PivotTable is the Count of Code Number by Company.


The fifth Recommended PivotTable is the Average of Total by Company.


At the bottom of the Recommended PivotTable we have the choice also to create a Blank PivotTable and to Change Source Data.

Blank PivotTable - Change Source Data

If we select Blank PivotTable a new Blank PivotTable will be created where we just have to select the appropriate PivotTable Fields in order for our PivotTable to be created as shown in the image below.

Blank PivotTable

If we select Change Data Source, the Choose Data Source dialog box will appear so we can select the source all over again in order to be represented in our PivotTable.

Choose Data Source

Whatever we choose our PivotTable will appear in a new spreadsheet as we can see below. We are still able to format, rearrange and do whatever else is necessary so we can represent our data in the most professional way.

PivotTable Fields

So who needs to be an expert in PivotTables in order to create one? Piece of cake!!!

You can also check out the video below describing the Recommended PivotTables in Excel 13.

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on February 6, 2013, in Excel English 2013, Microsoft Office 2013 English and tagged , , , , , , , , , . Bookmark the permalink. Comments Off on Recommended PivotTables in Excel 13.

Comments are closed.