In this article, we will examine the quick analysis tool in Excel and what can be done by using this function.

You can find the tool appears any time you select a set of cells.

It offers you various options and is a very helpful tool when it comes to analyzing data in Excel.

However, you must first activate the tool if it is not already turned on.

Or, you can turn it off if you dont want to display this tool.

For both, you need to go to the File tab on the Excel menu and click Options.

Then, on the General tab you will see Show Quick Analysis options on selection is written.

Check its box to turn on the tool or uncheck if you want to turn it off.

Instead of going through the tabs and selecting options, you can easily press CtrlQ on the keyboard and the quick analysis will appear.

You can either add data bars or color your cells or use other options.

Color option allows you to insert different colors to your data; you can color them in order to differantiate and distinguish.

In case you have some numbers and you want to see how they are valued based on a criteria, then icon set is there for you.

By adding icons to your numbers, you can see how their values change.

If you want to do more with your numbers, there is the option to highlight the cells which is greater than a particular value.

Click on the greater on the tab and it will open a window that you can enter your constraint value and choose the formatting color.

Afterwards, all the values greater than that will be colored.

Select the data and then click on charts from the options the tool displays.

Then all you need to do is to insert your chart and it is ready.

It will do the analysis for you saving you from various efforts.

This Excel template includes sales tracking dashboard with pivot tables and charts so you dont have to create them from the scratch.

Just insert it and adjust your data, it is ready to use with its outstanding features.

It can be used for both rows and columns; a new row or column will be inserted once you select one of the options.

First make sure that there is an empty row below the selected data.

Where Is The Quick Analysis Tool In Excel For Mac