Log In

Interactive Tutorial

Quick Analysis Tool in Excel

What is the quick analysis tool in Excel

Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

Try this course with a Free Trial

Interactive Tutorial

Practice live in your browser. No software required.

Try It Now

Excel 2021 Basic Course

4 Hour Course Certificate

View Course

Excel 2021 Basic Cheat Sheet

Free quick tips and shortcuts to use and share.

Download Cheat Sheet

Reference Guide

Step-by-step instructions with screenshots.

Reference Guide
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.