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.
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.
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.
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.
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.
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.
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.
Posted on February 6, 2013, in Excel English 2013, Microsoft Office 2013 English and tagged Blank PivotTable, Change Data Source, Excel 13, Microsoft Office 13, Office 13, Office Smart, PivotTable, PivotTable Fields, Recommended PivotTables, Smart Office. Bookmark the permalink. Comments Off on Recommended PivotTables in Excel 13.