How to Use the Excel 2013 Quick Analysis Tool
How to Add Calculated Fields to Pivot Tables in Excel 2013
How to Create a Pivot Table with the Excel 2013’s Quick Analysis Tool

How to Use the Recommended Pivot Tables Button in Excel 2013

You can generate a new pivot table in Excel 2013 in a snap with the new Recommended Pivot Tables command button if creating a new pivot table with the Quick Analysis tool in Excel 2013 is too much work for you. To use this method, follow these easy steps:

  1. Select a cell in the data list for which you want to create the new pivot table.

    Provided that your data list has a row of column headings with contiguous rows of data, this can be any cell in the table.

  2. Select the Recommended PivotTables command button on Insert tab of the Ribbon or press Alt+NSP.

    Excel displays a Recommended PivotTables dialog box. This dialog box contains a list box on the left side that showing samples of all the suggested pivot tables that Excel 2013 can create from the data in your list.

  3. Select the sample of the pivot table you want to create in the list box on the left and then click OK.

As soon as you click OK, Excel creates a new pivot table following the selected sample on its own worksheet (Sheet1) inserted in front of the others in your workbook. This pivot table is selected on the new sheet so that the Pivot Table Fields task pane is displayed on the right side of the Excel worksheet window and the PivotTable Tools contextual tab is displayed on the Ribbon.

You can use the options on this task pane and contextual tab to then customize your new pivot table.

image0.jpg
blog comments powered by Disqus
Use Excel Pivot Tables to Get Top and Bottom Views
How to Move Pivot Charts in Excel 2013
How to Move Pivot Charts to Separate Sheets in Excel 2013
Create a Histogram with a Pivot Table for Excel Dashboards
How to Format Values in the Pivot Table in Excel 2013
Advertisement

Inside Dummies.com