How to Do a Growth Analysis in Excel

Tracking business growth is fundamental, not just a nice-to-have. It shows you what’s working, what's not, and where you should focus next. Thankfully, you don't need a fancy data science degree, all the number-crunching can be done in Microsoft Excel. This guide will walk you through exactly how to set up your data, calculate key growth metrics, and visualize your progress clearly and effectively.

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

First Things First: Prepare Your Data for Growth Analysis

Before you can calculate anything, your data needs to be clean, simple, and organized. A poorly structured spreadsheet will make analysis a complete headache. For any growth analysis, you need two core elements at a minimum: a time period and a metric.

Create a simple table with at least two columns. Let's imagine you're analyzing monthly website traffic.

• Column A: Period (e.g., January, February, March)
• Column B: Metric (e.g., Website Sessions)

Your spreadsheet should look something like this:

Pro Tip: Keep it simple. Avoid merging cells, adding extra text in your data columns, or including empty rows between your data points. Clean data is the foundation of good analysis.

How to Calculate Period-Over-Period Growth Rate

The most common type of growth analysis is period-over-period (PoP) growth. This tells you the percentage change from one period to the next - think Month-over-Month (MoM), Quarter-over-Quarter (QoQ), or Year-over-Year (YoY).

The Formula for Growth Rate

The formula for calculating growth is straightforward:

(New Value - Old Value) / Old Value

Multiplying the result by 100 gives you the percentage. So, a result of 0.25 is a 25% growth rate.

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

Step-by-Step in Excel

Following our website traffic example, let's calculate the Month-over-Month growth rate.

1. Add a New Column: Add a new column to your table called "MoM Growth."

2. Enter the Formula: You can't calculate growth for the first period (January) because there's no "old value" to compare it to. So, start your formula in the cell next to your second period (February).

If your spreadsheet looks like this:

• A1: Month
• B1: Website Sessions
• A2: January
• B2: 10,000
• A3: February
• B3: 12,500

Your first growth formula will go in cell C3. The formula is:

=(B3-B2)/B2

3. Format as Percentage: After hitting Enter, you'll see a decimal (e.g., 0.25). To make it readable, select the cell, go to the "Home" tab on the Excel ribbon, and click the percent (%) symbol in the "Number" group. Excel will automatically multiply by 100 and add the percent sign, displaying 25%.

4. Drag to Autofill: Now for the easy part. Click on cell C3 again. You'll see a small square dot in the bottom-right corner of the cell outline. Click and drag this dot down to the bottom of your data set. Excel will automatically apply the formula for all the subsequent rows, correctly calculating the growth for each month.

Your finished table should now look like this:

Negative percentages aren't errors, they represent a real decrease in the metric for that period.

Calculating Compound Annual Growth Rate (CAGR)

Period-over-period growth is great for understanding short-term volatility, but what if you want to know your average rate of growth over multiple years? Simply averaging the monthly or annual growth rates can be misleading because it doesn't account for compounding.

That's where the Compound Annual Growth Rate (CAGR) comes in. CAGR calculates the constant, steady growth rate over a period, providing a smoothed-out number that's more useful for long-term strategic planning.

The CAGR Formula in Excel Syntax

The formula for CAGR might look intimidating, but it's simpler than you think once broken down.

= ( (Ending Value / Beginning Value)^(1 / Number of Periods) ) - 1

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

Step-by-Step CAGR in Excel

Let's use a new example: analyzing annual revenue over five years.

1. Set Up Your Data: Your data will be yearly.

The "Number of Periods" is the number of growth intervals, not the total number of data points. For data from 2020 to 2024, there are 4 growth periods (2020 to 2021, 2021 to 2022, etc.). A simple way to count this is (Count of data points - 1).

Assuming your revenues are in cells B2 to B6:

• Ending Value: B6 ($300,000)
• Beginning Value: B2 ($150,000)
• Number of Periods: 4

2. Enter the Formula: In an empty cell, type the following formula. You can use cell references to make it dynamic.

=((B6/B2)^(1/4))-1

3. Format and Interpret: After formatting the cell as a percentage, you'll get 18.92%. This means that, on average, your revenue grew by 18.92% each year from the start of 2020 to the end of 2024.

Visualizing Growth: Using Charts to Tell a Story

Numbers and percentages are great, but a chart can convey a trend in seconds. Line charts are perfect for illustrating growth over time, while column charts are excellent for comparing discrete periods.

Creating a Line Chart for Growth Trends

1. Select Your Data: Highlight your original data - in our first example, the 'Month' and 'Website Sessions' columns, including the headers.

2. Insert the Chart: Go to the "Insert" tab on the ribbon. In the "Charts" section, find the "Line or Area Chart" icon and select a simple 2D line chart.

3. Customize Your Chart: Excel will instantly generate a chart. You can improve it with a few clicks:

• Click on the chart title to give it a descriptive name like "Monthly Website Session Growth."
• Add axis titles by clicking the chart, then the "+" sign that appears on the top right, and check the box for "Axis Titles."
• Change the colors or style from the "Chart Design" tab to match your brand or report.

Comparing MoM % Growth with a Column Chart

You can also visualize the growth percentages themselves to see volatility.

1. Select Your Data: This time, highlight the 'Month' column and the 'MoM Growth' column. You can do this by holding the Ctrl (or Cmd on Mac) key while selecting the non-adjacent columns.

2. Insert the Column Chart: From the "Insert" tab, choose the "Column Chart" icon and select a simple 2D Clustered Column chart.

This will give you a clear visual of positive and negative growth periods, making it easy to spot big wins and performance dips.

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

Analysis Best Practices and Common Pitfalls

Performing the calculations is just the first step. True analysis comes from interpreting the results correctly.

1. Always Look for Context

Growth doesn't happen in a vacuum. A 30% jump in traffic is great, but why did it happen? Did you launch a new ad campaign? Was there a big press mention? Pair your data with your business activities to understand the story behind the numbers.

2. Don't Be Fooled by Small Numbers

If you get 10 visits one month and 20 the next, that's 100% MoM growth. While technically correct, it's far less impactful than going from 10,000 to 20,000 visits. Always consider the absolute numbers alongside the percentages.

3. Plan for Seasonality

Nearly every business has seasonal trends. An e-commerce store will likely see a huge spike in Q4. For seasonal businesses, a Year-over-Year (YoY) comparison is often much more insightful than a MoM comparison. Comparing December's sales to November's might show a dip, but comparing it to last December's sales gives you a true measure of growth.

Final Thoughts

Understanding and calculating growth in Excel is a skill that puts real power in your hands. Now you know how to structure your data, calculate both period-over-period and compound growth rates, and visualize those trends to tell a compelling story about your business performance.

While an Excel growth analysis is incredibly useful, the process often starts with a tedious manual step: downloading and cleaning CSVs from multiple platforms. To help teams like yours skip the data prep entirely, we built Graphed. It connects directly to your marketing and sales tools like Google Analytics, Shopify, and Salesforce, so your data is always live and in one place. You can create these kinds of growth reports in seconds with a simple prompt, without ever touching a spreadsheet again.