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