In excel you can do Period-over-Period (POP) analysis and Year-over-Year (YOY) analysis. Year-over-Year analysis will compare the selected period to the same period last year. For example, comparing August of the current year to August of the previous year. YOY can be weeks, months, quarters, or years. Period-over-Period will compare the selected period to the preceding period. For example, August of the current year to July of the current year.
We will use PivotTables to do our YOY and POP analysis. We use Difference from and we will calculate percentages.
Chapters:
00:00 Introduction
01:25 Create PivotTable
03:47 Subtotals in Group
04:21 YoY by Month
05:16 Compare to the previous year
07:17 Period over Period
08:30 Percentages
10:11 Highlighting negatives
11:26 Negative percentages in red font
12:12 Closing remarks
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtraining.com/camtasia
○ Screenshots - Snagit - chrismenardtraining.com/snagit
○ KZread keyword search - TubeBuddy - 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!