Where Is The Quick Analysis Tool In Excel And How To Use it?

quick analysis tool

Excel offers many options for data visualization, but it can be confusing to know where to begin. Luckily, the Quick Analysis tool lets you browse through many different options even if you don’t know exactly what you want.

Use the Quick Analysis tool in Excel to quickly analyze your data. Insert tables, apply conditional formatting, and more quickly. In this article, we will introduce where is the quick analysis tool in Excel and how to use it.

Read More: How To Repair Netherite Tools?

What Exactly Is A Quick Analysis Tool?

The QUICK ANALYSIS TOOL is a collection of some selected options that you can use to analyze the data quickly. Charts, a pivot table, and sparklines are among its features. It also considers the type of data you have chosen—text, dates, or numbers—and presents you with options accordingly.

If you are using Excel 2010 or a lower version, you won’t be able to find the Quick Analysis Tool because it was introduced with Excel 2013.

Few options on the quick analysis tool are dependent on the data type you have chosen, but the majority of them are fixed.

For instance, you will have different options in the conditional formatting tab if you choose dates as opposed to numeric data.

Hovering over any of the quick analysis tool’s options reveals a preview of the selected data.

Where Is The Quick Analysis Tool?

The Quick Analysis button will always be visible when you choose a cell range in the lower-right corner of the selection. You can select from a range of charts, sparklines, conditional formatting options, and more when you click it. The best part is that the options will be customized to your particular data, making it easy for you to find pertinent visualizations.

If You Cannot See the Quick Analysis Tool Button

If, for some reason—and there is a very slim chance that this will happen—you are unable to see a quick analysis button when you select the data, you should see if it is disabled in the options.

Go to File Tab ➜ Options ➜ General ➜ Tick Mark (Show Quick Analysis options on selection)

As I previously stated, it was first made available in Excel 2013; therefore, if you are currently using a version earlier than that, you must update.

Keyboard Shortcut

Yes, there is a keyboard shortcut for the quick analysis tool.

Control + Q

You must first select the data before using this keyboard shortcut.

Here’s one more advantage. You can still use the keyboard shortcut to open a quick analysis tool even if it is disabled in the Excel options.

The right-click menu allows you to activate the quick analysis button as well.

How To Use Quick Analysis Tool?

  1. Choose the data cells that you want to examine.
  2. Notice the Quick Analysis Tool icon that is displayed at the bottom of the data. Click it.
  3. In the Quick Analysis gallery, hover your mouse over each option to see a preview.
  4. Click a menu item to choose it.

Tips For Use Quick Analysis Tool

1. Quickly Create Data Bars

When working with numeric data (conditional formatting data bars), this option is very helpful.

You must first click on the formatting tab and quick analysis button and then choose the “Data Bars” option.

To the chosen data, it will immediately add solid data bars (in blue). It is quick, right?

Go to Home Tab Styles Conditional Formatting Manage Rules if you want to alter the color or any other customizations.

2. Create In-cell Charts With Sparklines

Sparklines can be added quickly from the quick analysis tool and can be used to insert an in-cell chart.

  • Click the quick analysis button after selecting the data that the sparklines should be added.
  • Choose the type of sparkline you want to insert by going to the sparklines tab.

Sparklines for the selected data will appear right away in the cells you selected.

3. Quickly Add Grand Totals

You can add totals in a variety of ways using the totals tab, which also offers options for both columns and rows.

  1. Sum: To expand a table’s total row or column.
  2. The table should now have an average row or column.
  3. Add an average row or column to the table by counting.
  4. % Total: To add a row or column with a percent total to the table.
  5. Running Total: To add a running total row or column to the table.

4. Analyze Dates With Quick Analysis Tool

Using the quick analysis tool, you can quickly analyze dates in your data if they are present.

When you open it, a few quick options for conditional formatting are displayed for data analysis.

  • Last Month: You can use this option to highlight every date from the previous month.
  • Last Week: to emphasize each week’s worth of dates.
  • Greater than: highlights every date that is later than the one you specify.
  • Less Than: highlights every date that is less than the target date.
  • Equals To: the dates that are equal to the date you specify are highlighted.

5. Create A Pivot Table With Quick Analysis Tool

The option to insert a pivot table is displayed when you click the quick analysis button and select the tables tab.

You are shown every option for building a pivot table based on the data you have chosen.

If you don’t want to use the suggestions, you can click the more button, open the suggested PivotTables, and then click the blank pivot table to build a pivot from scratch.

6. Highlight Unique And Duplicate Values

You can decide which values are unique and which are duplicates when you choose text data.

Other Posts You Might Like: