Use an Excel Pivot Table to Group Data by Age Bracket

Several viewers asked me to demonstrate some other ways to -Group a Field- in a Pivot Table. In this tutorial, I show you how to create a Frequency Report by Age Bracket.

Before I start the Pivot Table Demonstration, I show you how to calculate someone's age using the -undocumented- =DATEDIF() Function in Excel.

In the Pivot Table, I change the result from -Summarize Values By- to the -Show Vales As- setting. Finally, I apply Conditional Formatting to the Pivot Table.

Danny Rocks
The Company Rocks

[counthere]

10 years later, this is still a helpful video! Thank you!

[lildoc]

Can I just say you are a life savior!!! I am from a medical background and always found IT programs a bit difficult to understand...yes even simple functions of Word Excel baffle me! Your instructions are so simple to follow and although I use Open office, I still managed to translate your instructions on it successfully. My clinical audit looks awesome now, thanks to you! God bless!!!

[DannyRocksExcels]

My pleasure! I am delighted that I could help you with my tutorial!

Danny Rocks
The Company Rocks

[DannyRocksExcels]

Thank you! I am happy that you enjoyed my Excel tutorial.

I appreciate you adding your feedback.

Danny Rocks
The Company Rocks

[FormerlyNintendoJames]

this is exactly what I needed - I was like "there's no way I can learn how to use a pivot table for this sheet I'm working on in under 10mins" and then lo and behold... I DID IT! haha

thanks so much for a really well explained and demonstrated tutorial, really appreciate it!

[DannyRocksExcels]

Thank you Richard. I appreciate your very kind words.

Thanks for adding your feedback.

Danny Rocks
The Company Rocks

[dorothyneri]

Watching this now (July 27, 2016), the same day you created this video four years ago. Thank you for posting this vid. I needed this badly today at work.

[epohster]

Thank you very much for your quick reply!
In the source table I changed the cell formatting of the "Age" column from 'Number' to 'General' and then refreshed the pivot table and it worked - the grouping was automatically updated to 10-11 12-13 14-15 an so on! I'm so happy!
Thank you so so much! I've learned such a great deal from your videos!

[richardkinzer]

ur excel skills r gr8! ur camtasia skills r stellar & ur teaching style is smooth as silk!!

[DannyRocksExcels]

Thank you for your kind words. I am pleased that I could help you with my tutorial.

Danny Rocks
The Company Rocks

[viniduits]

Thank you so much . Been struggling with my age categorizing for a week. This really helped alot <3

[tomskmtmathew]

Thank you very much for this briefing. After an extensive search to find a means to categorise my data, I found yours to be the most helpful. Thanks heaps.

[DannyRocksExcels]

Thanks for your kind words about my tutorials.

Here are the key points for grouping by age in a Pivot Table:
1) Drag Age Field into either Row or Column to get unique (text) values for ages
2) Select single cell prior to Grouping Field
3) Select proper "increment" - e.g. by 2
4) Drag Age Field a second time - this time into Values - use the COUNT Function

DATEDIF - is a great function - remember that it counts complete years / complete months, etc.

Danny Rocks
The Company Rocks

[AsadAliShahadenium]

This video saved me hours of work.. Many Thanks Sir..

[munenedenis]

Many thanks Danny you're simply the best

[SilverWolf]

THE MOST HELPFUL TUTORIAL I'VE SEEN

[nayah]

Thank you so much! This saved me from hours of manual tally for my study. I was ble to breath after watching this.

[danheffable]

You are the best. This is the most helpful tutorial I have ever seen. Thank you!!

[datalab]

Thank you for this *brother*, it helps me a lot.

[candicevitalien]

Excellent tutorial. It made my work so much easier. Loved the step-by-step process.