The results of the calculations are displayed in the row beneath or column beside the selected cells. From here you have the option to apply common functions-Sum, Average, Count, % Total, and Running Total-on either the columns or rows in the range. When you want to perform basic calculations of the selected data, select the Totals tab. To create other chart types (beyond what Excel recommends), click More Charts to open the Insert Chart dialog box. Mouse over a chart icon to see a preview of that chart type, then click the icon to create the chart beside the selected range. The tool recommends a handful of chart types most applicable to the data in your range. Use the Chart tab in the Quick Analysis gallery to quickly create the most common chart types from the selected data. You can also choose to highlight cells that are greater than average or are in the top 10% of values. So, for example, you can apply data bars, different background colors, or even different icons to cells within your range that meet specified criteria. The Formatting tab in the Quick Analysis gallery enables you to apply conditional formatting to the selected data. That makes the Quick Analysis tool a smart tool for any Excel users. And you’ll only see those options that are appropriate to the data you’ve selected. You don’t have to surf Excel’s various Ribbons to do what you want to do chances are, it’s right there in the Quick Analysis tool. Not only does it place the appropriate creation commands in a single place, it also previews the results before you apply the commands. The nice thing about the Quick Analysis tool is how easy it makes using some of Excel’s more advanced functions. Click a tab to view the available actions, which may differ somewhat based on the type of data selected. The Quick Analysis gallery presents five tabs for different actions: Formatting, Charts, Totals, Tables, and Sparklines. Click the Quick Analysis button at the lower right corner of the selected range. Click this button (or press Ctrl+Q) to display the Quick Analysis gallery. (The selected cells must contain data Quick Analysis isn’t available-or needed-for an empty range.) Position your cursor over the bottom right corner of the range and you see the Quick Analysis button.
The Quick Analysis tool becomes active when you use your keyboard or mouse to select a range of cells in a worksheet.