![Excel PivotTable Group Data [Video]](https://www.myonlinetraininghub.com/wp-content/uploads/2013/04/pivot_tip_group_data_thumb.png)
In this second tutorial, in my 3 part series on PivotTable tips and tricks, Iām going to show you how to group data like dates into years, quarters or months, and ages into groups like this PivotTable below:
Watch the Video
For best viewing watch the video in 720p HD full screen.
Download the Workbook
Enter your email address below to download the sample workbook.
Written Instructions - How to Group Dates
1. Ensure your data is in a date format, i.e. numbers not text.
2. Create your PivotTable and right click on any date in the PivotTable > Group
3. Select the groupings from the 'By' list:
4. Click OK
If you get an error it's most likely because your source data isn't formatted as a date.
You can use Text to Columns to fix this.
Written Instructions - How to Group Ages into Bands
1. Create your PivotTable and right click on any number in the age group column header of the PivotTable > Group
2. Edit your start and end ages or leave as Auto.
3. Change the 'By:' number to suit your needs:
4. Click OK
Nicci says
Thanks for the above video Mynda! Bless you! š
Mynda Treacy says
You’re welcome, Nicci. Glad we could help.
Suman Dutta says
Thank you for your vedio of pivot table presentation. your sound is clear but vedio charecter too small so kindly guide to me how to display screen in Big charecter.
Thanks again for presentation. Its help for me.
Kind regards
Suman
Mynda Treacy says
Hi Suman,
You can watch the video in full screen. Simply start playing the video and then click on the ‘Full Screen’ icon in the bottom right hand corner of the video screen.
Kind regards,
Mynda.