There is a small icon that appears every time you select a data range in Excel. It sits in the bottom right corner of the selection, looks like a little lightning bolt, and most of us instinctively ignore it. After all, Microsoft’s Office programs are riddled with random icons that don’t make sense to many of us.
You might dismiss it as a misleading UI element, or click it once, not immediately understand what you’re looking at, and never look at it again. That’s a mistake, because that little icon is your gateway to an Excel feature I’d be lost without: the Quick Analysis tool.
This little box does more than you think.
What a quick analysis actually reveals.
When you click Quick analysis icon (or press Control + Q to invoke it), a small floating menu will appear with five tabs: Formatting, Charts, Totals, Tables, and Sparklines. Each of these tabs is a shortcut to a specific type of analysis that would normally require navigating through an otherwise cluttered Excel ribbon menu.
Instead of going to the ribbon and scrolling your way through submenus, you can use the Quick Analysis menu to quickly visualize and summarize what your data will look like with options for conditional formatting, charts, totals, tables, and more. You can think of it as a context-aware assistant that reads the data you select and immediately displays the most relevant options. It doesn’t give you all the Excel features you need, just the ones that make sense based on the data range you’ve chosen. That’s the whole point of a quick analysis tool – it meets you where you already are, mid-choice, mid-thought, when you need it.
If the tool doesn’t appear on the selection, go to File > Options > General and make sure the Show quick analysis options on selection. box is checked.
Now, if this all sounds a bit overwhelming, keep in mind that the Quick Analysis tool won’t appear if you have merged cells in your selection. It also won’t activate if you select non-contiguous ranges, say you’re holding down Control to get two separate columns. This requires a clean block of data to work with. In addition, the tool works on any non-empty selection, permanently reducing the time spent on common tasks by eliminating the need to interact with the top-packed ribbon.
Formatting without the usual pain
Excel’s Formatting tab is a rabbit hole of interesting features, half of which you accidentally discover when you’re trying to achieve a specific type of formatting. The problem with this is that it takes time and a bit of fiddling around to get what you need. Using conditional formatting correctly can also be a handful if you haven’t done it before.
The Quick Analysis Tool, as the name suggests, is a very quick way to do this. Select a column of sales data, open Quick Analysis, and you can immediately use the data bar. These are in-cell progress bars that turn columns of raw numbers into visual comparisons in one click. Alternatively, you can apply a color scale where lower values are red and higher values are green, making it clear at a glance which metrics are improving and which aren’t.
Another icon set option can add little arrows or traffic light symbols to your cells—quite useful when you’re sharing a spreadsheet with someone and don’t want them to get lost in the numbers. There are also Great Than and Top 10% options that let you quickly highlight outliers without writing complex conditional formatting rules.
All of these actions can be done from the Excel Formatting tab, but they will take a few minutes, half a dozen clicks, and some configuration to work. With instant analysis, they’re ready to go in a two-second hover and click.
Charts in a few clicks
Convert raw numbers into visual form almost instantly.
Another impressive section of the Quick Analysis tool is the Charts tab. Once you select your data and open the tool, Excel will automatically suggest several chart types based on what it detects in your selections. You can hover over each selection and preview how your data will look in real time. When you find one you like, click on it, and your chart will be ready.
It’s not always right, meaning sometimes you have to do it the old-fashioned way. But more often than not, you’ll find a suitable chart type in seconds. The Preview option is also great, as it lets you see how the data is presented without having to create multiple charts or peek at the little preview icons that Excel displays in the Insert menu ribbon.
You’re picking the wrong chart — let Excel’s new Agent Mode decide for you.
Agent mode reads your data and creates what fits reality.
Live previews remove any guesswork. If you’ve ever inserted a bar graph only to realize that a line chart would better explain what you’re trying to show, Quick Analysis solves the problem before you encounter it by showing both chart views with your selection. And if quick recommendations don’t cut it, you can click away. More charts button within the tool to see a complete list of Excel’s recommended charts. If that’s not enough, you can switch to All charts Tab to take full control.
Total — No formula required.
Instant sum and average without touching the ribbon
Now I’ll admit that typing =SUM() or =AVERAGE() doesn’t take much time, but you still have to supply the cell ranges for these formulas to work properly, and that’s where a lot of mistakes happen. With quick analysis, you select your data, go to Total tab, and immediately below your columns or to the right of your rows, easily add a row, average row, count, running total, or total percentage.
However, you have to pay attention to the two rows of icons. The top row adds the totals to the bottom of your column, and the bottom row adds them to the right of your rows. It’s easy to mix at first, but you’ll build up the memory you need in just a couple of uses. Excel formulas also break all the time, so using the Quick Access tool gives you an easy way to get fully functional results.
Sparklines deserve more attention.
Small charts that illustrate trends at a glance.
A sparkline is a money line chart that resides within a single cell. In my opinion, this is one of the most beautiful ways to display data that Excel has ever offered. And while it’s usually buried in chart options, the Quick Actions tool puts it front and center.
Select a row of data for a particular product, such as sales figures, and Quick Analysis can add a line chart, column chart, or win/loss chart directly to the cell at the end of that particular row. You can apply this to all your rows to instantly generate individual trend indicators for each row in your spreadsheet. What is increasing, decreasing, picking up quickly and performing well is great.
Nothing new, just fast
Familiar tools, now easier to use.
A quick analysis tool doesn’t ask you to learn anything new. It only gives immediate results for what you are already doing right. Instead of memorizing yet another keyboard shortcut or digging through the Ribbon, you let Excel suggest the next step and show a preview before you commit.
Excel has finally solved its biggest data entry problem, and it’s a lifesaver.
A single click in the Data tab can catch almost all issues.
Once you get used to clicking that little box, it’s hard to go back. So the next time you’re staring at a boring grid of numbers, don’t reach for the formula, reach for the quick analysis tool and see what wonders it does for you.