Quick Analysis Tool in Excel

The Quick Analysis function helps you quickly format your data into a chart, table, summary formula, sparkline, or highlighted figures with just a few simple steps.

Use the Quick Analysis Button

  1. Select the cell range you want to summarize.
    Quick Analysis

    Be careful when selecting your data. The Quick Analysis button will not appear when using the Ctrl key to make multiple selections.

  2. Click the Quick Analysis button.
  3. Select the type of analysis tools you want to use.
    Quick Analysis
    • Formatting: Highlight data using conditional formatting.
    • Charts: Chart the selected data.
    • Totals: Create common summary formulas.
    • Tables: Summarize data in a table or PivotTable.
    • Sparklines: Mini charts placed in single cells.
Excel Cheat Sheet

FREE Quick Reference

Click to Download

Free to distribute with our compliments; we hope you will consider our paid training.