Excel for Microsoft 365 Excel 2019 Excel 2016 Excel 2013 Quick Analysis takes a range of data and helps you pick the perfect chart with just a few commands. Select a range of cells. Select the Quick Analysis button that appears at the bottom right corner of the selected data. Quick Analysis Tool on Tablet. Android version = 7.0. Excel Version = 1.0.1 (16.0.8) Would like to use Quick Analysis tool however shortcut box doesn't automatically appear when data is selected. CTRL + Q on virtual keyboard doesn't seem to function either. Hello, If you select your data, the quick analysis button should appear at the bottom right corner of the screen. It can also be accessed by typing Ctrl + Q. Quick analysis is a practical Excel tool which lets user to instantly create different types of charts and offers options like conditional formatting, pivot tables or sparklines. You can find the tool appears any time you select a set of cells.
Excel 2013 New Features – Quick Analysis Tool
The Quick Analysis tool as the name suggests allows us to select data on our sheet and then quickly analyse it using the short cut options available to us from the tool.
Once you select your data, if the option is applicable, you will see the Quick Analysis tool appearing in the bottom right of your selection. When you click on this tool the following screen will appear. You can see from this screen that there are 5 possible options.
- Formatting
The formatting option, allows you to apply conditional formatting options without having to go to the HOME tab and choosing Conditional formatting. Very quickly you can apply the options of data bars, colour scales and so on. Note that the last icon on the formatting view us clear format, so if you apply a format like Colour scale and then decide you do not like it you can clear it very easily. Also, if you just hover over these icons you will see a preview before you click, as when you click you have applied the format and would need to clear format to delete it.
- Charts
The Charts option, allows you to create a chart from the selected data. Again if you hover over the chart types you will see the chart before deciding on the one to choose.
- Totals
The Totals option, allows you to create a totals line at the bottom of your selected data. For example if you choose Sum when you data is highlighted it would give you a new line of data under your existing data with the sum of each of your columns. Click Average and you will get a new line with the average total at the end of the data and so on. The arrow pointing to the right shows that there are more options on this window, click on the arrow and you will see more total options.
- Tables
The Tables option, allows you to convert the selected data into a table format. Once in table format, you can use all the tools in the Table Tools tab. It also allows you to convert the data into a pivot table.
- Sparklines
Where Is The Quick Analysis Tool In Excel 2007
The Sparklines option, allows you to create a line, column or Win/Loss Sparkline in the cells to the right of your selected data. Once the Sparkline is created further options can be accessed through the Sparklines tab.
Be Brilliant at Excel. Save Hours each week and add Professional Certification to Your Resume
Even Microsoft use us to teach their employees Excel
Where Is The Quick Analysis Tool In Excel On A Mac
Get access to The Ultimate Excel Training Course Bundle