Microsoft Excel Tips and Tricks
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.
Credit Chris Menard