Year-Over-Year analysis in Excel using a PivotTable

Year-Over-Year (YOY) growth compares one period, usually a quarter or a month, against the same period twelve months before. You can compare Q3 of 2021 against Q3 of 2020. Another example is comparing the month of September 2021 to September 2020.

You can even compare one day to the same day in the previous year. A restaurant may want to compare Mother's Day revenue in one year against Mother's Day during the previous year.

Advantage of Year-Over-Year Analysis
The advantage of Year-Over-Year analysis is it removes the effects of seasons. For example, say your business revenue rose 15% from May to June. That initially sounds great, but when you examine the previous year in June, revenue rose 30%. Same months but a different example. Suppose June of this year is $10,000 and you think that is great, but when you compare to June of last year, June the previous year was $14,000. This is why year-over-year analysis is a great tool.

Excel file is on my blog post page
https://chrismenardtraining.com/post/...

Chapters:
0:00 Intro
0:50 What you would analyze
1:39 Microsoft financials
2:50 Excel YOY - Quarters
3:30 PivotTable with Quarters
4:20 Expand/Collapse dates
5:25 Filter PivotTable
7:15 Why use YOY analysis
8:02 Coca-Cola financials
9:37 Excel YOY - Months
11:28 MTM - Month to Month

List of items you could compare with YOY
Revenue
Net income or profit
Subscribers
New customers
Expenses
Orders

#msexcel #yearoveryeargrowth #chrismenardtraining #yearoveryearanalysis

Chris Menard's website
https://chrismenardtraining.com

And make sure you subscribe to my channel!

- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!