Скачать или смотреть Group Dates in a Pivot Table

Grouping dates in a pivot table is one of those nice slice and dice features. If you get dates in a MM/DD/YYYY or DD/MM/YYYY format and want to see your data aggregated or rolled up into months, quarters, years or any other interval you need to group the dates. What is nice is you can expand and collapse the months (or whatever grouping or ungrouping you chose) to simplify your views. The other nice thing is that you can put the pivot table data into a chart and use the expand and collapse capabilities from the table to affect the chart or use the expand/collapse buttons on the chart itself. This chart can also be put on a separate sheet so you don't have to see the table.

A note that is discussed in the video is what happens when you can't group and it may have something to do with the date format (Hint: It's not working because of text). There's another note on how this date grouping can be automatically done or undone.

🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p

🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...

📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough

⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53

⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G

⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101

📝 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 https://www.buymeacoffee.com/dough

#excel
#msexcel
#doughexcel

~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
   • Convert Table in a PDF File to Excel  
~-~~-~~~-~~-~