Once you click on it, it will insert a Sparkline in the cell after the last cell.Īfter inserting a sparkling and you decide you want to change its type, then just select your data and follow the same steps.After that, click on the type of sparkline you want to add.First of all, select the entire range of data like below and press Ctrl + Q and then select Sparklines.And, you can easily use them in your dashboards. The benefit of using sparklines is that you can create in-cell charts with it, which don’t take much space. You can also add a sparkline with the quick analysis tool. Insert a small trend line with sparklines. It uses a combination of SUM function and SUBTOTAL function for this. Once you click on it, it will instantly insert a new column to your table with product share percentage.Scroll to “%Total” (yellow icon) and click on it.Select your data and press Ctrl + Q and then select Totals.
If you want to use the manual method for this, you will need to insert a formula manually.īut, you can do this automatically using the quick analysis option. Let’s say you have a list of products with their sales quantity and you want to calculate the product share. Insert percentage share with just a few clicks. The best part is that it will always recommend you the best suitable charts.
Now, you have a list of recommended charts from which you can hover over with your mouse and it will show you a live update of the chart based on your data.First of all, select your data table and press Ctrl + Q and then Charts.In Excel, there is an option “Recommended Charts” which you can use to get a suggestion of charts and you can use that option in the quick analysis as well. Most of the times you have a specific chart in your mind to present your data and you insert it without considering that there can be an another type of a chart which you can use. So, whenever you are in hurry just remember: Select your data -> Ctrl + Q & Tables -> Click Blank Button.Ĭhoose right chart for your data in a flash.
The best thing about this method is, it inserts a pivot table without showing you “Create Pivot Table Window”. Once you click on it, it will instantly create a pivot table adding a new worksheet.After that, press Ctrl + Q and select Tables.Yes, you can use the quick analysis tool to quickly create a pivot table. Let’s say if you want to add a running total for a row instead of a column, you can use blue option.
In the Total tab, there are two types of options, one is blue which is for rows and second is yellow which is for columns.
So now, let’s get started with the 5 + 1 Reasons You Should Use Excel’s Quick Analysis Option!ĭOWNLOAD OUR FREE “QUICK ANALYSIS CHEAT” SHEET
In Excel (2013 or above version), whenever you select some data from a range of cells you get a small icon on the bottom right hand corner, as you can see below:Īnd, I’m sure you have noticed this so many times.