Quickly Group List by Age Ranges - Excel

To quickly group a list by age ranges in Microsoft Excel you may think of creating an extra helper column and then entering the group ranges in the respective cells and then doing some kind of outline group. Don't do that! Instead use a Pivot Table to help group records. Here's an Excel #shorts video to show you how.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to
www.buymeacoff...
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

[@t4tumi488]

Very easy and useful tip

[@DougHExcel]

Thanks @t4tumi488, glad it helped!

[@khanyingobese1007]

LIFE SAVER! Thank you! God bless ✨

[@DougHExcel]

No problem 😊

[@charulohia8477]

thanks for the tip, very useful

[@DougHExcel]

Glad it was helpful!

[@rsssingh3172]

Thanks sir

[@DougHExcel]

Welcome!

[@bendavis9951]

You just saved me. 🤟🏿

[@md.golamsaklain2317]

How to create first & last?

[@LisaLM-sp1xn]

How would I do this if I need group net sales into 13 different buckets?

[@DougHExcel]

Try Grouping Data with Power Query
ua-cam.com/video/v72PR3o09P8/v-deo.html

[@jeffkoh9905]

But power pivot doesnr allow this.-.

[@jitender60]

If I want first group is 20-25 but second grup between 25-40 and last one is 40-end age how please solve the problem?

[@MatthewBohli-rm5xs]

you ever figure this out lol?

[@Thefaysl]

I am not getting the option to choose from which and by how many after clicking group

[@maarnasrul1717]

yes,so i am😅

[@iuniversol]

Me either. I know this is a short bit dude flew through this.

[@angobertineasua8258]

Me too

[@jocelynlevesque5336]

Don't have the same excel view as you and you're going too fast through the steps. Thanks for trying though!

[@DougHExcel]

Sorry about that😓