The Quick Analysis tool (available in Excel 2016 and Excel 2013 only) let you total your numbers quickly. Whether it’s a sum, average, or count you want, Excel shows the calculation results right below or next to your numbers.
Show totals for your numbers using Quick Analysis
- Select the cells that contain numbers you want to add or count.
- Click the Quick Analysis button
in the bottom-right corner of the selection. - Click Totals, move your cursor across the buttons to see the calculation results for your data, and then click the button to apply the totals.
Add meaning to your data using Quick Analysis
- Select the data you want to examine more closely.
- Click the Quick Analysis button
in the bottom-right corner of the selection. - Explore the options on the Formatting and Sparklines tabs to see how they affect your data.
For example, pick a color scale in the Formatting gallery to differentiate high, medium, and low temperatures.
- When you like what you see, click that option.
Show your data in a chart using Quick Analysis
- Select the cells that contain the data you want to show in a chart.
- Click the Quick Analysis button
in the bottom-right corner of the selection. - Click the Charts tab, move across the recommended charts to see which one looks best for your data, and then click the one that you want.
- Note: Excel shows different charts in this gallery, depending on what’s recommended for your data.