Excel shortcuts

How to Calculate Percent Change in Excel: The Shortcut Method

If you work with data in Excel, you'll inevitably need to calculate percent change at some point. Percent change is a common way to measure change over time, whether you're tracking sales data, stock prices, or any other type of data that fluctuates. While you could calculate percent change by hand, it's much easier to do in Excel using a simple formula.

In this article, we'll show you how to calculate percent change in Excel using the shortcut method. This method is quick and easy, and it will save you time in the long run.

To calculate percent change in Excel, you'll need to use the following formula:

=(new value-old value)/old value

For example, let's say you have a list of sales data for the past year, and you want to calculate the percent change from month to month. In the first column, you would enter the old value (the sales figure from the previous month). In the second column, you would enter the new value (the sales figure from the current month). Then, in the third column, you would enter the formula =(B2-A2)/A2 to calculate the percent change.

You can also use this formula to calculate percent change over a longer period of time, such as from year to year. To do this, you would simply enter the old value in the first column and the new value in the second column. Then, in the third column, you would enter the formula =(B2-A2)/A2 to calculate the percent change.

You can also use this formula to calculate percent change for multiple values at once. To do this, you would enter the old values in the first column and the new values in the second column. Then, in the third column, you would enter the formula =(B2-A2)/A2 for the first value, =(B3-A3)/A3 for the second value, and so on.

Once you've entered the formula, you can format the cells to show the percent change as a percentage. To do this, select the cells that contain the percent change values and click the "Percentage" button on the "Home" tab of the ribbon. This will format the cells to show the percent change values as percentages.

You can also use this method to calculate percent change for multiple values at once. To do this, you would enter the old values in the first column and the new values in the second column. Then, in the third column, you would enter the formula =(B2-A2)/A2 for the first value, =(B3-A3)/A3 for the second value, and so on. Once you've entered the formula, you can format the cells to show the percent change as a percentage. To do this, select the cells that contain the percent change values and click the "Percentage" button on the "Home" tab of the ribbon. This will format the cells to show the percent change values as percentages.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.