As mentioned above, there are five tabs of Quick Analysis tool. Quick analysis tool help understand and manage data. Note: If you use Excel version lower than Excel 2013, you need to upgrade to Excel 2013 or later to use Quick Analysis Tool in Excel. To find the quick analysis tool, please review the following steps:Ĭheck the “Show quick analysis options on selection” option on the right side of the “General” tab.

If the quick analysis tool is disabled, the quick analysis tool will not appear even after selecting data. Why is Quick Analysis tool Not Showing Up? The above options may vary depending on the data you select. In the Quick Analysis Toolbar, there are 5 categories: Note: If you select an entire row or column and an empty cell, the Quick Analysis tool will not appear. Switch between tabs and click options to create visualizations.

Then you will see a series of data analysis options. Select a cell or data table and the Quick Analysis button will appear in the lower right corner of the selection.Ĭlick the Quick Analysis icon or press Ctrl+Q (Windows) or Command+Q (MAC) after selecting data to open the Quick Analysis tool.

Quick analysis button excel