Excel Quick Analysis Tools

Note: This feature is available from Excel 2013 onwards.

When analyzing the data, instead of going through various tabs, we can use the quick analysis tool to insert charts, visualizations, different formatting techniques, formulas, tables, PivotTables, and sparklines.

These can be created in a few seconds.

You are free to use this image on you website, templates, etc., Please provide us with an attribution linkHow to Provide Attribution?Article Link to be HyperlinkedFor eg:Source: Quick Analysis Tools in Excel (wallstreetmojo.com)

Where are Quick Analysis Tools in Excel?

Now, the important question is where this tool is. This tool appears when we select the data range in Excel. For example, look at the below data.

Once we select the data, we can see a small icon to the bottom right of the selection.

We know you have seen this icon before, but you have not worried about this. Unfortunately, not many Excel users make use of this wonderful tool. We will show the various kinds of analysis tools it has.

How to use Quick Analysis Tools in Excel? (Top 5 Tips)

Tip #1 – Quickly Insert Formatting into the Data

Tip #2 – Quickly Analysis Inserting Chart to the Data

We can also insert a chart to the selected data using the quick analysis tools. Once the data is selected, click on “Charts.”

  • Click on this icon to explore all the possible options. We have “Formatting,” “Charts,” “Totals,” “Tables,” and “Sparklines.” Let us look at “Formatting” now. Placing a cursor on the required formatting option can see the immediate impact on our data. We have placed a cursor on “Data Bars” and inserted data bars according to the size of the numbers. Similarly, we can use “Color Set,” “Icon Set” in Excel, “Greater Than,” and “Top Value,” and more importantly, we can clear the Excel formatting with the “Clear” option. Click on the “Color Set” to insert different colors. Click on “Icon Set” to get icons for your numbers. If you want to highlight values greater than 140, click on the “Greater Than” option below the window. Mention the value as “140” and choose the formatting color. Click on “OK.” We will have mentioned formatting for all the values which are >140.

We have placed a cursor on “Data Bars” and inserted data bars according to the size of the numbers. Similarly, we can use “Color Set,” “Icon Set” in Excel, “Greater Than,” and “Top Value,” and more importantly, we can clear the Excel formatting with the “Clear” option.

Then, select the required chart here. We have chosen a clustered column chart. Then, the quick analysis tools are ready to use.

Like this, we can use various charts that suit our data structure.

Tip #3 – Quickly Analysis through Totals

We can also insert totals into the data by choosing “TOTALS” under “Quick Analysis.” Under this, we have a variety of formulas.

We can insert the SUM, AVERAGE, COUNT, % Total, Running Total, SUM to the Right, Average to the Right, count to the right, and running total to the right.

Based on the requirement, we can make use of these formulas. Now, we have applied RUNNING TOTAL in ExcelRUNNING TOTAL In ExcelRunning Total in Excel is also called as “Cumulative” which means it is the summation of numbers increasing or growing in quantity, degree or force by successive additions. It is the total which gets updated when there is a new entry in the data.read more.

We got the result for the running total, as shown below:

Similarly, we can use SUM, AVERAGE, etc.

Tip #4 – Quickly Analysis through Tables

We can also insert the table format in excelInsert The Table Format In ExcelExcel comes with a number of table styles that you may quickly apply to a table format. In Excel, you can design and use a new custom table style of your choice. read more and PivotTable to the data under “Tables.” Then, click on “TABLES” and choose the option you want to use.

A table will convert the range of data to table format data.

If you click “Blank,” it will insert a PivotTable in the new sheet in excelThe New Sheet In ExcelWhen we open a new workbook, there are three worksheets available by default. However, if you want to insert a new worksheet into the workbook, the shortcut key is Shift + F11.read more.

Tip #5 – Quickly Analysis through Sparklines

We can insert SparklinesInsert SparklinesSparklines in Excel are similar to a chart within a cell. They are tiny visual representations of the data’s trend, whether it is increasing or decreasingread more to the right of the data under the “SPARKLINES” option.

Based on our selection, it will display the sparklines to the left of the data.

We have selected “Column” sparkling, as shown below.

This article is a guide to Quick Analysis Tools in Excel. Here, we discuss the top 5 tips to use quick analysis tools in Excel with examples and downloadable Excel templates. You may learn more about Excel from the following articles: –

  • Running Total in Power BIMatch Data in ExcelMatch Data In ExcelThere are various methods to match data in excel. To match the data in the same column, we can use conditional formatting from the home tab or check the data in two or more different columns; we can use conditional functions like the if function.read moreMixed References in ExcelTypes of Charts in Excel