5Stars. The more I work w/ PivotTbls the more I like them. Grouping is a handy feature. I'm sure u have more than 1 example for others to see...cuz theres reasons this could be handy. Grouping Monthly invoices from various vendors for example(just my rambling to show i'm listening :). Ohhh, and you didn't mention the 'butterfly'@2:55 :P. (I know its a basic feature, but for ppl just learning including me LOL, it would help to hear you talk about why it shows up, and why ignoring it is good :P
Another great video that shows you how to group by Month:
Excel Magic Trick #49 Pivot Table w Grouped Dates
I don't know what you mean when you said:
"Ohhh, and you didn't mention the 'butterfly'@2:55 :P. (I know its a basic feature, but for ppl just learning including me LOL, it would help to hear you talk about why it shows up, and why ignoring it is good :P"
The AutoFill Options button :). AKA 'butterfly'. LOL. I forgot where I got that term from :P.
periwink 3 years ago
Dear periwink,
OK, I will do it!
--ExcelIsFun
ExcelIsFun 3 years ago
5Stars. The more I work w/ PivotTbls the more I like them. Grouping is a handy feature. I'm sure u have more than 1 example for others to see...cuz theres reasons this could be handy. Grouping Monthly invoices from various vendors for example(just my rambling to show i'm listening :). Ohhh, and you didn't mention the 'butterfly'@2:55 :P. (I know its a basic feature, but for ppl just learning including me LOL, it would help to hear you talk about why it shows up, and why ignoring it is good :P
periwink 3 years ago
Dear periwink,
Thanks for listening!
Another great video that shows you how to group by Month:
Excel Magic Trick #49 Pivot Table w Grouped Dates
I don't know what you mean when you said:
"Ohhh, and you didn't mention the 'butterfly'@2:55 :P. (I know its a basic feature, but for ppl just learning including me LOL, it would help to hear you talk about why it shows up, and why ignoring it is good :P"
If you tell me what that means, I will help!!!!
--ExcelIsFun
ExcelIsFun 3 years ago