If you would like more options, click More to open the Recommended PivotTables dialog box. Hover over any PivotTable option to see if any are similar to the type of table you are looking for.

Click the icon to open the menu, then click Tables from the top row of menu options.

When you do so, the Quick Analysis Tool icon will appear in the bottom right corner of the selection. Highlight the data you want to include in the PivotTable.

Open the sheet with the data you want to analyze.

To follow using our example below, download Create a PivotTable.xlsx Images in this article were taken using Excel 2013 on the Windows 7 OS. The steps below will demonstrate how to create PivotTables using Excel’s Quick Analysis Tool and will apply only to Excel 2013 or later. The developers at Microsoft Office offered some help for that in Excel 2013.

Quickly summarize and compare variations in data groupingsīut with all that flexibility, PivotTables can be somewhat intimidating to implement.

When used to their full potential, PivotTables can: PivotTables do more than generate graphs out of one or two data points. One of the most powerful tools for analysis is the PivotTable. Once you have collected a set of data, Excel can help you organize it and analyze it. Storing information is only part of the useful things Excel spreadsheets can do. Despite these limitations, the Quick Analysis Tool can still be a helpful tool for quickly analyzing small sets of data.By Tepring Crocker Categories: Excel®, PivotTables Tags: how to create pivottables This means that it can’t effectively analyze data from multiple worksheets or from an external database. This means that it can’t effectively analyze data that includes text or non-numerical values.įinally, the Quick Analysis Tool is limited to analyzing data from a single worksheet. Second, the Quick Analysis Tool is only designed to work with numerical data.

This means that it can’t effectively analyze data that has more than two variables.

First, it only supports two-dimensional data. There are a few limitations to the Quick Analysis Tool in Excel. What Are the Limitations of the Quick Analysis Tool? You can also use the tool to create charts and graphs of your data. You can use the Quick Analysis Tool to quickly summarize data, find averages and sums, and calculate percentages. The Quick Analysis Tool is an Excel feature that allows you to quickly analyze data in a table or range of cells.

Microsoft excel quick analysis button