Background Information
The Quick Analysis Tool in Microsoft Excel allows you to quickly analyze data, or convert your data to a chart or table.
Access the Quick Analysis Tool
- Select a range of cells to be evaluated.
- When the cells are selected, the Quick Analysis Tool appears in the lower-right corner of the range.
- Click the Quick Analysis Tool icon to view options available for the data range.
Quick Analysis Tool Options
Quick Analysis Tool options include:
- Formatting – most include Conditional Formatting features
- Charts – view Recommended Charts for the selected data
- Totals – add a row to display a formula such as: Total, Average, Count, Running Total
- Tables – convert the range to a Table
- Sparklines – create in-cell charts, such as trend lines
To apply any of these options, complete the following:
- Click on one of the headers in the Quick Analysis Tool display.
- Within the header, hover over an option to preview the result.
- Select an option when ready.
Note: For more information, please refer to the Job Aides Library.
To review images or save/download/print a copy of this Job Aide, please select the pdf attachment.