How to calculate a growth rate in excel

You can watch a video tutorial here.

Growth rate shows how much progress there is compared to a previous period. To do that in Excel, it requires some mathematical knowledge to execute it.

Step 1 – Click on an empty cell

Click on the empty cell and start adding in the formula.

Step 2 – In the formula bar right in the following:
(Present ValuePast Value-1)*100

For this example, B3 is the present value and B2 as the past value. Do take note that I intentionally skipped a single line mainly because you always have to take the past value as reference.

Step 3 – Press Enter

Pressing Enter automatically shows the output of the formula.