In order to get the Average Annual Growth Rate in Excel, we must first calculate the annual growth rates for each year using the formula = (Ending Value - Beginning Value) / Beginning Value, and then average them.
Besides the original table, enter the below formula into the blank Cell C3 and, and then drag the Fill Handle to the Range C3:C11.
2. On the Home tab, select the Range D4:D12, then click the Percent Style button to adjust the decimal places by clicking the Increase Decimal or Decrease Decimal buttons.
3. Enter the formula below into Cell F4 and click the Enter key to average all annual growth rates.