Excel: Year-over-Year (YOY) analysis w/ a PivotTable

Year-over-Year (YoY) analysis compares the change in a company's financials or data for two comparable periods, typically the current and prior periods as of the fiscal year-end date. We use YOY to calculate growth. Two examples of YOY would be comparing August 2022 to August 2021 or Q3 of 2022 vs. Q3 of 2021. You can even compare one day with YOY. If you were a restaurant, you may compare Valentine's day 2023 vs. Valentine's day 2022 to see the percentage growth.

In this video, I'll use a PivotTable to calculate Year-over-Year growth for 12 months in one year to 12 months in the prior year.

Chapters:
0:00 Intro
0:38 YOY Example - Microsoft
0:59 Create PivotTable
2:19 Manual YOY
2:40 PivotTable YOY

#chrismenardtraining #msexcel #chrismenard #microsoft #microsoftexcel

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!