Top Ten New Features in Excel 2013
7 of 10
If you’re a newbie at creating pivot tables for the Excel data lists you create as well as data tables that you import from stand-alone database management programs, you can now get Excel to recommend and create one for you.
All you have to do is locate the cell cursor in one of the cells of the data list and select Insert→Table→Recommended PivotTables on the Ribbon. Excel 2013 then opens the Recommended PivotTables dialog box showing you a whole list of different pivot tables that you can create on a new worksheet in the current Excel workbook by simply clicking the OK button.