How to Use Quick Analysis

You’ve been there: staring at a spreadsheet filled with rows and rows of raw data. You know there are valuable insights hiding in those cells - trends, outliers, top performers - but the thought of manually creating charts, applying formatting, and building pivot tables makes you want to close the lid on your laptop. Luckily, Excel has a powerful, often-overlooked feature designed to turn that data drudgery into instant discovery: the Quick Analysis tool. This article will show you exactly how to use it to spot trends and make sense of your data in seconds, not hours.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What is the Quick Analysis Tool, Anyway?

Think of the Quick Analysis tool as a smart, context-aware shortcut menu for data analysis. When you highlight a range of data in Excel, a small icon appears at the bottom-right of your selection. Clicking on it opens a pop-up window with suggestions for formatting, charts, totals, tables, and more, all tailored to the specific data you’ve selected. Instead of hunting through the ribbon for the right option, you get a curated list of the most common and useful data analysis actions right at your fingertips.

The whole point is speed. It's designed to help you quickly explore your data and visualize it in different ways, taking the guesswork out of turning numbers into insights. This is especially useful when you're not entirely sure what you're looking for yet and want to experiment with different views of your data without committing to building a formal chart or report.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

How to Access the Quick Analysis Tool

Getting to the tool is simple. There are two primary ways:

1. The Icon: Select a range of cells containing your data (including headers). You'll immediately see the Quick Analysis icon - a small box with a lightning bolt - appear in the bottom-right corner of your highlighted selection. Click on it.
2. The Keyboard Shortcut: For those who prefer to keep their hands on the keyboard, select your data range and press Ctrl + Q. This will instantly open the Quick Analysis window.

Once you open it, you’ll see a series of tabs across the top: Formatting, Charts, Totals, Tables, and Sparklines. Let's walk through what each one does.

A Deep Dive into the Quick Analysis Tabs

Each tab in the Quick Analysis menu offers a different way to interpret or structure your data. Let's use a simple sales report as an example to see how each feature works in practice. Imagine our data looks something like this, showing monthly sales by different marketing channels:

(Example Data)

• Channel | January Sales | February Sales | March Sales
• Google Ads | $12,500 | $14,200 | $15,100
• Facebook Ads | $8,300 | $7,900 | $9,500
• Email Marketing | $15,800 | $16,500 | $18,200
• Organic Search | $11,200 | $11,800 | $12,400

1. The Formatting Tab

This tab is all about conditional formatting, which applies visual cues to your data so you can spot patterns at a glance. Instead of digging through menus, you can get instant visual feedback.

• Data Bars: Adds colored bars inside each cell, with the length of the bar corresponding to the cell's value. Select the January sales numbers and click "Data Bars," and you’ll instantly see that Email Marketing has the longest bar, clearly identifying it as the top performer.
• Color Scale: Applies a color gradient to your cells based on their values. For example, a red-to-green scale could instantly show you your lowest (red) and highest (green) sales figures. It’s perfect for seeing the distribution of values.
• Icon Set: Places icons like arrows or traffic lights in each cell to indicate its value relative to others. Hover over the "Icon Set" options to see arrows pointing up for high values, sideways for mid-range, and down for low ones. It's a great dashboard-style visual.
• Greater Than...: This lets you highlight cells that meet a certain condition. You could use it to instantly highlight all months where sales exceeded $15,000.
• Top 10%: Automatically finds and highlights the top 10% of values in your selection, making it easy to identify your top-performing channels without any sorting or formulas.

2. The Charts Tab

Tired of going through the chart creation wizard? The "Charts" tab in Quick Analysis intelligently recommends chart types based on your data structure. Simply select all your data (including the channel names and month headers) and open the tool.

Excel will offer previews of different charts like:

• Clustered Column or Bar Chart: The most common choice for this type of data. It would create a bar chart comparing the sales performance of each channel side-by-side for each month.
• Stacked Bar Chart: Useful for seeing the total sales for each month and understanding how much each channel contributed to that total.
• Line Chart: Perfect for visualizing the trend of each channel's sales over time. You’d quickly see if Google Ads performance is trending up while Facebook Ads is flat.

Just hover your mouse over each recommendation to see a live preview. When you find one you like, click on it, and Excel will instantly insert a fully formed chart onto your sheet. It’s a huge time-saver and a great starting point for building a more polished report.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

3. The Totals Tab

This tab helps you quickly calculate sums, averages, counts, and more without writing a single formula. It gives you two main buckets of options: blue-icon options add calculations in a new row at the bottom, and yellow-icon options add them in a new column to the right.

Calculations in a New Row:

• Sum: Select your sales numbers for all three months. Clicking "Sum" will automatically add a new row at the bottom with the heading "Total" and calculate the total sales for each month.
• Average: Instead of summing, this calculates the average sales per channel for each month.
• Count: Counts the number of entries in each column.
• % Total: Calculates what percentage each month's total contributes to the grand total of all sales.
• Running Total: This adds a row showing a cumulative sum across the columns - great for tracking progress toward a quarterly goal.

Calculations in a New Column:

Similarly, selecting the numerical data for just one row (e.g., all sales for Google Ads) and then choosing a yellow-icon "Sum" will add a new column on the right that totals the quarterly sales for each channel.

4. The Tables Tab

This tab is about bringing structure and advanced functionality to your plain data range.

• Table: The first and most basic option converts your data range into a formatted Excel Table (the kind with filterable headers and banded rows). Why is this great? It makes sorting and filtering your data incredibly easy. Once you convert it to a table, you can click the new drop-down arrows in the headers to sort sales from highest to lowest or filter to see just one channel's performance.
• PivotTable: This is the hero feature for summarizing data. With one click, Excel instantly creates a new sheet with a suggested PivotTable. For our sales data, it might automatically set it up with Channels as rows and the sum of sales as values, giving you a clean summary of total sales by platform for the entire quarter. It’s the fastest way to build a PivotTable when you need to slice and dice large datasets.

5. The Sparklines Tab

Sparklines are mini-charts that fit inside a single cell, giving you a quick visual of a trend without taking up much space. Select the three sales figures for Google Ads ($12,500, $14,200, $15,100) and click on the "Sparklines" tab.

• Line: Inserts a tiny line graph in an adjacent cell showing the trend of those three numbers.
• Column: Inserts a miniature column chart instead.
• Win/Loss: A specialized sparkline that shows only positive and negative movements.

After you click one, you can drag the fill handle down to instantly create a sparkline for every other channel. It’s an incredibly effective way to build a compact dashboard, letting you compare performance trends across multiple rows simultaneously.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Putting It All Together: A Practical Workflow

Here’s how you can see this tool transforming your workflow from a manual chore to a rapid discovery process a marketing analyst might follow:

1. Highlight and Explore: You get a raw CSV export of campaign performance. You select the entire data range, hit Ctrl + Q.
2. Get a Visual Feel: You hover over the Formatting options. The Color Scale immediately shows you a sea of red on one particular campaign's cost-per-click, flagging it for review.
3. Summarize the Bottom Line: You click over to Totals and use Sum to add a new column calculating the total conversions for each campaign.
4. Visualize the Results: You flip to the Charts tab and select the "Clustered Bar" chart preview. Instantly, you have a professional-looking chart comparing each campaign’s total conversions. You see two campaigns dramatically outperforming the rest.
5. Drill Down with a Pivot: To understand why, you select the data again, go to Tables, and click PivotTable. Now you can easily drag the "Ad Group" or "Audience" field into your PivotTable to see if a specific segment is driving the strong results for those top campaigns.

In less than a minute, you’ve gone from a lifeless block of numbers to identifying your best and worst performers and generating a hypothesis about why they performed that way - all thanks to the Quick Analysis shortcuts.

Final Thoughts

The Quick Analysis tool is one of Excel’s best features for lowering the barrier between you and your data. It helps you quickly format, summarize, and visualize information so you can move from raw data to actionable insights without getting lost in menus and formulas. It's the perfect first step for anyone looking to feel more confident exploring the stories hidden in their spreadsheets.

While Quick Analysis in Excel or Google Sheets is fantastic for data that's already in one place, we know that is rarely the case for most marketing and sales teams. Typically, the messiest part of reporting is just getting the data together - manually downloading CSVs from Google Analytics, Facebook Ads, Shopify, and your CRM. We built Graphed to solve exactly this problem. Instead of wrangling spreadsheets, you can connect your data sources in seconds and use simple, conversational language to ask questions and build the exact dashboards you need in real-time. It’s like having a data analyst on your team who handles all the data pulling and visualization for you.