Excel Pivot Table: How to show Year over Year comparison

In this tutorial, I will show you how to do a Year over Year comparison of your data in a Pivot Table in Excel.

After grouping your data by Years and Months, add your date columns to your Pivot Table as 'Column Labels' or 'Filters.'

This setup allows you to easily analyze trends, and enhance data visualization.

Got questions or insights to share? Feel free to drop them in the comments below.

Timestamp:
00:00 Intro
00:12 Show Year over Year comparison
00:38 This is how you do it!

🔴 RECOMMENDED VIDEOS/PLAYLISTS
🎥 Financial functions: https://www.youtube.com/watch?v=FrD2B_nEnSc&list=PLQHFVtY7qRavbgxjqGGE6t3TSlpToYztl&ab_channel=ExcelCogTutorials
🎥 Common errors: https://www.youtube.com/watch?v=cDBSxgH_WLU&list=PLQHFVtY7qRatNX2w9ov3B2On7FdJiniXG&ab_channel=ExcelCogTutorials
🎥 How to tutorials: https://www.youtube.com/watch?v=LZkMf8tMnDw&list=PLQHFVtY7qRaufg0mmtiP3NWvHJCo0WT07&ab_channel=ExcelCogTutorials
🎥 Regular functions explained: https://www.youtube.com/playlist?list=PLQHFVtY7qRasFz48oVe-4IbO-jQfY1_9v

Видео Excel Pivot Table: How to show Year over Year comparison канала Cogwheel Learning