The Quick Analysis Tool brings the most commonly used formatting, charting and summary tools into one convenient location. The tool allows you to quickly create an Excel table or Pivot Table, create a new chart, add totals to columns or rows, insert Sparklines and many many more options.
To view / use the Quick Analysis Tool
- Select the range of cells you want to summarise.
- Click the Quick Analysis command button which will appear at the bottom right of the selected range.
- Click the tools category you want to use.
- Click the action you want to use.
If you hover over an action Excel will give you a preview of this action before you commit to any changes.