Where is the Quick Analysis Tool in Excel – The Best Guide

where is the quick analysis tool in excel

Where is the Quick Analysis Tool in Excel – The Best Guide

Do you know where is the quick analysis tool in Excel?

Excel is used for the execution of analytical functions all around the world. The quick analysis feature lets you analyze data without further ado. When you need conditional formatting and row or column totals calculation, this feature is one of the highly recommended features. Besides, you can even add charts, tables, and sparklines with the quick analysis tool.

What is the Quick Analysis Tool?

A combination of selected options used for data analysis is called the quick analysis tool. As already mentioned, you can add tables, conditional formatting, pivot tables, and charts. Apart from that it also lets you understand what options you need to choose based on the data type.

quick analysis tool

Where is the Quick Analysis Tool in Excel Ribbon? 

Unfortunately, you will not find a direct way to use the quick analysis tool in the Excel ribbon. On the lower right side, when data is selected Excel displays a small icon that opens the quick analysis tool while clicking on it.

quick analysis ribbon

In case, when you are unable to find the quick analysis button even after selecting data, you may have to follow these steps to activate this option.

Open the File tab and click on the Options button.

quick analysis enable

From this, you need to choose the General option and then Tick Mark.

You will now see the quick analysis tool.

Keyboard Shortcut to Open Quick Analysis Tool:

You can use a combination of shortcut keys to open the quick analysis tool in Excel.

Press CTRL + Q to open the quick analysis tool.

Before applying this shortcut, you have to select the data.

How to Use the Quick Analysis Tool in Excel?

Based on what you need to do, you can use this tool accordingly. The quick analysis tool has many options to choose from. Also bear in mind that the Quick analysis tool chooses its suggestion based on what type of data you have selected.

Let’s see how it happens:

  • Here you will get to know how you can calculate row or column totals with Quick Analysis Tool.
  • For this function, choose the data with the column and rows and click on the quick analysis button.
  • Press CTRL + Q shortcut keys from the keyboard.
  • The Quick Analysis menu will appear, from which you need to choose Totals and select the type of Total you required. The options include Row Totals, Blue color, Column Totals, Amber Color, etc.
  • Apart from these options, you will also find running total, average, percentage, and count under the Totals options in the menu.

quick analysis tool use

  • Now, select the SUM option that appears with the Blue color styling given below the Totals part of the Quick An analysis tool.

quick analysis tool use2

Another Method to Use the Quick Analysis Tool for Data Analysis:

When your data contains numeric, you may need to apply Data Bars with conditional formatting.

quick analysis for data analysis

  • Now, click on the quick analysis button and choose the formatting tab.
  • Select the Data Bars option and you will see the addition of solid data bars in Blue color.

Isn’t it quick?

In case, you need to modify the color or some other changes, follow this step:

  • Open the Home tab and choose the Styles option.
  • Click on the Conditional Formatting and then choose Manage Rules.

quick analysis for data analysis2

To Sum Up:

You will find the Quick Analysis Tool handy and quick while using it. Although this tool is not present on the ribbon, however, you can still locate it in Excel to make your data analysis quick and easier.

Full Excel Course Certification $7 $147Enroll Now



We are available on WhatsApp. To Start a chat click below and we'll get back to you as soon as possible

× How can I help you?