Quick analysis is a handy tool initially provided in the 2013 version of Excel. Microsoft has provided lots of other updates for its customers over the years, and a quick analysis is no exception.
Excel provides some of the best data analysis tools out there, providing lots of tools, formulas, and visualization charts for its users.
Let’s have a look at how to use the quick analysis tool in excel!
What Is Quick Analysis In Excel?
A quick analysis tool is a great tool within excel. It will speed up your work and will mean that, instead of having to work through all of the various tabs on excel, you can use this tool to insert visualizations, charts, formulas, tables, and pivot tables.
All of this can be achieved in seconds with this great tool!
How To Use Quick Analysis
The quick analysis tool is fairly quick and easy to use. It allows you to easily convert your data into a table or chart.
Whether you’re using the 2013 version of Excel, or the 2016 version, the feature will work in the same way.
Follow these steps below to use the tool:
- Select the data. Make sure that you select all of the cells that contain the data that you want to analyze.
- When you do this, the quick analysis tool icon should appear underneath the data. It will be an icon. You should click on this tool.
- You will then be able to roll over every one of the options that quick analysis has to offer. This will show you a preview of the options.
- Once you have chosen your option, you can click on it. This will produce the chart or table that you have selected.
What Are The Benefits Of Quick Analysis?
Quick analysis has many great features that will help you to benefit. These include the following:
Add A Running Total
Quick analysis lets you add a running total. This is one of the most effective ways to analyze data and quick analysis allows you to do this very quickly. Follow these steps to activate the running total:
- Select your data and then click on the icon for quick analysis as explained above.
- When you are in the quick analysis section, go to ‘totals’. When you have done this, you should scroll through to the end of the totals option and click on ‘running’.
- Once you have done this, you will get another column added to your table or chart which contains the running total. This will be calculated using the subtotal function.
On the running total option, there are yellow and blue options. The yellow option adds a column and the blue option adds a row containing the running total.
Able To Insert A Pivot Table
When you use the quick analysis tool, you will be able to rapidly insert a pivot table. This is very easy to do, and will come in very handy for you. Follow these simple steps to do this:
- Select your data.
- Select the quick analysis tool and choose the tables option.
- When you are in the tables option, you should click on ‘blank’.
- Once you click on the blank option, you will get a new worksheet with a pivot table added to it.
This is super simple and straightforward and is very useful when it comes to quick analysis.
It is sometimes difficult to decide which chart will work best for you. This is another benefit of quick analysis in excel.
Quick analysis gives some suggestions for chart types that you can use. Often, you will know which type of chart you want to use, however, sometimes you will benefit from a bit of advice!
In order to access these recommended charts, follow these steps:
- Select your data, and head to the quick analysis tool as above.
- Head to the ‘charts’ option, and hover over the option with your mouse. When you do this, you will see a live update of the chart based on the data that you have.
- If you click on the chart icon, you will get this chart instantly inserted onto your sheet.
If you are looking for a chart that is not on the list, you can always head to ‘more charts’. This will recommend to you the most suitable charts.
You can insert the percentage share using quick analysis in excel very easily.
If you have a list of products with all of their sales quantities, you will be able to calculate the product share using this tool.
You can enter a formula for this, however, if you want to use the quick analysis tool to do this, follow these steps:
- Select your data, go to the quick analysis tool and select ‘totals’.
- Scroll down to the ‘%total’ tool, and select it.
- Once you have selected it, you can add a new column to your table. This can be added with the product share percentage.
In order to work this out, excel uses the SUM and subtotal functions.
Greater Than Values
If you are looking to highlight some greater than values, you can use the quick analysis option in order to do this.
Follow these steps to carry this out:
- Firstly, you will need to select your values in order to apply conditional formatting.
- After this, you simply need to go to the quick analysis tool and select the ‘greater’ icon.
- Once you have done this, you should click on it in order to display a pop-up window. At this stage, enter the greater than value and select a color.
- Click ‘OK’. This will then highlight the greater than values.
Quick analysis in excel is super quick and easy to use. It is a great tool and something you should definitely use if you are an excel user! There are many different benefits to this tool, so you should try it out now to see how it can help you.