Excel’s Quick Analysis Tool is the easiest way to analyze your data instantly using different tools (Formatting, Charts, Totals, Tables or sparklines)

1. Quick Analysis Excel 2010
2. Quick Analysis On Mac
3. Microsoft Excel Quick Analysis Tool
4. Where Is The Quick Analysis Tool In Excel For Macs

In today’s lesson, we will explain how to use this feature in Excel.

If you're using Excel 2007, click the Microsoft Office Button, and then click Excel Options In the Manage box, select Excel Add-ins and then click Go. If you're using Excel for Mac, in the file menu go to Tools Excel Add-ins. In the Add-Ins box, check the Analysis ToolPak check box, and then click OK. To enable the Data Analysis tool in Excel, go to the File menu’s Options tab. Once we get the Excel Options window, from Add-Ins select any of the analysis pack, let’s say Analysis Toolpak and click on Go. This will take us to the window from where we can select one or multiple Data analysis tool packs which can be seen in the Data menu tab.

How to turn on the Quick Analysis feature?

You can choose two methods to activate the tool.

Go to Excel Option, on the General tab. Check Show Quick Analysis options on selection. From now the QAT toolbar will appear by default.

If you like using keyboard shortcuts, apply the Ctrl + Q combination.

Click the Quick Analysis button on the bottom-right corner of the range. The custom toolbar appears. You can choose from the following tools: Formatting, Charts, Totals, Tables, and sparklines.

Formatting Tables using Quick Analysis Tool

Quick Analysis Excel 2010

Now let us see how to apply conditional formatting using QAT. If you want to learn all about conditional formatting, we strongly recommend you our definitive guide.

The key differences between QAT and regular methods:

We get a quick live preview and select the option you want. The Quick Analysis Tools provides the most used functions:

• Data Bars, color-based highlighting, icons sets
• “Greater than” quick formulas
• Top N percentage
• Clean formatting rules

That is all we require! Let us assume that you prefer the common way to use all of the conditional formatting features. Go to the Home Tab and click on the ribbon.

Inserting charts using Quick Analysis Tool

Select the data range then click Charts on the floating toolbar. The button that appears at the bottom right corner of the selected range. Based on the type of selected data, you’ll see the most recommended chart types with previews.

If you want to choose another chart type, go to the Chart tab on the Ribbon. Select your preferred chart type and click it.

How to use Totals?

The Totals function is useful if you want to perform a quick analysis. Just pick one of the available options, and a new row will be inserted.

Tables

Quick Analysis On Mac

Tables play an important role in data analysis. Click on the Table icon to convert the current range into a table. If you have a larger initial data set, you can create Pivot tables too. Tables help you sort, filter and summarize data.

Microsoft Excel Quick Analysis Tool

Sparklines

Where Is The Quick Analysis Tool In Excel For Macs

Sparklines are in-cell mini charts, and with their help, we can create a line, columns, and win / loss chart in single cells.