Excel's Quick Analysis tool: instant totals, charts, and formatting

Select a range of numbers and a small icon appears at the bottom-right corner of the selection. That’s Quick Analysis — a shortcut to formatting, charts, totals, and tables you’d otherwise build by hand.

Step 1: Select your data

Include the headers. Quick Analysis uses them to label whatever it generates.

Step 2: Open it

Click the icon at the corner of the selection, or press Ctrl + Q. A menu opens with five tabs, each previewing its options live as you hover.

Step 3: What’s on each tab

• Formatting — conditional formatting: data bars, color scales, icon sets, and rules like “highlight cells greater than.” Hover an option to preview it on your actual data before applying it.
• Charts — a handful of chart types Excel thinks fit your data, ready to insert with one click. Faster than picking a type manually when you just want to see the shape of the data.
• Totals — running sum, average, count, or percentage-of-total, added as a new row or column with real formulas — not static values.
• Tables — convert the range into a formatted Excel Table, or jump straight to building a PivotTable from it.
• Sparklines — tiny in-cell trend charts, one per row, useful for showing a pattern across many rows without a full chart taking up space.

Why bother

None of this is exclusive to Quick Analysis — everything it does is reachable through the ribbon. What it saves is the back-and-forth of picking a chart type, writing a SUM formula, or hunting for conditional formatting in the Home tab. For a first pass at unfamiliar data, it’s the fastest way to see what’s there before deciding what actually needs a proper pivot table or a handwritten formula from the function reference.