Question: how to calculate average percentage increase in excel?
Answer: Drag the fill handle from cell C3 to cell C8 to copy the formula to the cells below.
Column C will now have the yearly growth rates. Go to cell F4.
Assign the formula =AVERAGE(C3:C8) . Press Enter.