How to Add Comments to Excel 2013 Worksheet Cells
How to Sort on Multiple Fields in Excel 2013
Create Charts in Excel 2013 via the Quick Analysis Tool

Top 10 New Features in Excel 2013

Recommended PivotTables

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.

  • Add a Comment
  • Print
  • Share


Promoted Stories From Around The Web

blog comments powered by Disqus
How to Move Pivot Charts in Excel 2013
How to Set Regional Dates in Excel 2013
How to Customize the Excel 2013 Quick Access Toolbar
How to Share Excel 2013 Files
How to Describe a Custom Excel 2013 Function