{"id":3360,"date":"2018-11-10T11:12:55","date_gmt":"2018-11-10T11:12:55","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3360"},"modified":"2024-04-12T10:01:15","modified_gmt":"2024-04-12T10:01:15","slug":"year-over-year-growth","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/","title":{"rendered":"Year Over Year Growth in Excel"},"content":{"rendered":"\n
When you try to calculate the growth of your company, comparing data to the previous month is not always the best idea because the company may have peak and low demand seasons.<\/p>\n\n\n\n
The year-over-year comparisons help to analyze the company\u2019s performance and avoid seasonality. For example, many companies have big demand seasons during the holiday shopping season.<\/p>\n\n\n\n
Instead of comparing the current month to the previous one, it takes the current month and compares it to the same month last year. It\u2019s an easy and efficient way to check whether the company\u2019s performance is improving or worsening.<\/p>\n\n\n\n
Let\u2019s take a look at the following example.<\/p>\n\n\n\n This is what the chart looks like.<\/p>\n\n\n\n You can copy the following table.<\/p>\n\n\n\n If you want to calculate YOY growth for August 2019, use the following formula.<\/p>\n\n\n\n YOY<\/strong> = ((11.4 – 9.5) \/ 9.5) * 100<\/p>\n\n\n\n YOY<\/strong> = 20%<\/p>\n","protected":false},"excerpt":{"rendered":" When you try to calculate the growth of your company, comparing data to the previous month is not always the best idea because…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[170,192,190],"yoast_head":"\n<\/th> 2017<\/th> 2018<\/th> 2019<\/th><\/tr><\/thead> January<\/td> 3.5<\/td> 4.2<\/td> 4.8<\/td><\/tr> February<\/td> 3.7<\/td> 4.4<\/td> 5.5<\/td><\/tr> March<\/td> 3.6<\/td> 4.3<\/td> 5.4<\/td><\/tr> April<\/td> 3.4<\/td> 4.1<\/td> 4.6<\/td><\/tr> May<\/td> 3.2<\/td> 3.7<\/td> 4.1<\/td><\/tr> June<\/td> 3.1<\/td> 4<\/td> 5<\/td><\/tr> July<\/td> 7.2<\/td> 8.1<\/td> 9.8<\/td><\/tr> August<\/td> 7.9<\/td> 9.5<\/td> 11.4<\/td><\/tr> September<\/td> 6.2<\/td> 7<\/td> 8.7<\/td><\/tr> October<\/td> 6.1<\/td> 7.8<\/td> 9.1<\/td><\/tr> November<\/td> 5.8<\/td> 7.5<\/td> 8.8<\/td><\/tr> December<\/td> 5.1<\/td> 6.1<\/td> 7.5<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n