{"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
Year-Over-Year-Growth-in-Excel<\/a>Download File<\/a><\/div>\n\n\n\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

How to calculate year-over-year growth in Excel<\/h2>\n\n\n\n
    \n
  1. From the current month, sales subtract the number of sales of the same month from the previous year. If the number is positive that the sales grew.<\/li>\n\n\n\n
  2. Divide the difference by the previous year\u2019s total sales.<\/li>\n\n\n\n
  3. Convert the value to percentages.<\/li>\n<\/ol>\n\n\n\n

    Let\u2019s take a look at the following example.<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    This is what the chart looks like.<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    You can copy the following table.<\/p>\n\n\n\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

    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":"\nYear Over Year Growth in Excel<\/title>\n<meta name=\"description\" content=\"Learn how to calculate year-over-year growth in Excel to analyze your company's performance using a simple and efficient method to avoid seasonality.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Year Over Year Growth in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to calculate year-over-year growth in Excel to analyze your company's performance using a simple and efficient method to avoid seasonality.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-10T11:12:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-12T10:01:15+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/year-over-year-excel.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Year Over Year Growth in Excel\",\"datePublished\":\"2018-11-10T11:12:55+00:00\",\"dateModified\":\"2024-04-12T10:01:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/\"},\"wordCount\":208,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/year-over-year-excel.png\",\"keywords\":[\"file\",\"medium\",\"pinterest\"],\"articleSection\":[\"formulas\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/\",\"url\":\"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/\",\"name\":\"Year Over Year Growth in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/year-over-year-excel.png\",\"datePublished\":\"2018-11-10T11:12:55+00:00\",\"dateModified\":\"2024-04-12T10:01:15+00:00\",\"description\":\"Learn how to calculate year-over-year growth in Excel to analyze your company's performance using a simple and efficient method to avoid seasonality.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/year-over-year-excel.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/year-over-year-excel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Year Over Year Growth in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Year Over Year Growth in Excel","description":"Learn how to calculate year-over-year growth in Excel to analyze your company's performance using a simple and efficient method to avoid seasonality.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/","og_locale":"en_US","og_type":"article","og_title":"Year Over Year Growth in Excel","og_description":"Learn how to calculate year-over-year growth in Excel to analyze your company's performance using a simple and efficient method to avoid seasonality.","og_url":"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/","article_published_time":"2018-11-10T11:12:55+00:00","article_modified_time":"2024-04-12T10:01:15+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/year-over-year-excel.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Year Over Year Growth in Excel","datePublished":"2018-11-10T11:12:55+00:00","dateModified":"2024-04-12T10:01:15+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/"},"wordCount":208,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/year-over-year-excel.png","keywords":["file","medium","pinterest"],"articleSection":["formulas"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/","url":"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/","name":"Year Over Year Growth in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/year-over-year-excel.png","datePublished":"2018-11-10T11:12:55+00:00","dateModified":"2024-04-12T10:01:15+00:00","description":"Learn how to calculate year-over-year growth in Excel to analyze your company's performance using a simple and efficient method to avoid seasonality.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/year-over-year-excel.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/year-over-year-excel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/formulas\/year-over-year-growth\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Year Over Year Growth in Excel"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3360"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=3360"}],"version-history":[{"count":8,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3360\/revisions"}],"predecessor-version":[{"id":15339,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3360\/revisions\/15339"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=3360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=3360"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=3360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}