In this tutorial what I want to show you how to group your dates together. Excel usually does this automatically in later versions. It will look at your dates and group into days/months/quarters/years depending on your range of dates. However in earlier versions this doesn’t always happen automatically so what you need to do is do a right click and group on the dates. You can then choose how you want to group your data
If you want to get a deeper dive into Pivot tables, check out my book
Pivot Tables Explained – Unleash this Excel SuperPower and Convert your Data to Gold
Here is the file for you to work on.
In the second scenario and again this is one of my Judge Judy scenarios (“Real cases, real people”) where I got asked this question in class. A participant wanted to know how to group quantities together rather than dates. We use grouping again for that.
Here is the file for you to work on.
If you want to do a deeper dive into pivot tables, have a look at my book on pivot tables…