Question: how to calculate year on year growth percentage in excel?
Answer: Take your current month's growth number and subtract the same measure realized 12 months before. ... 
Next, take the difference and divide it by the prior year's total number. ... 
Multiply it by 100 to convert this growth rate into a percentage rate.