Excel Magic Trick 1456: PivotTable & Slicer to Create 8 Year Sales Report by Product & Month

In this video see how to create an 8 Year Span Monthly Revenue Report for a selected Product. Learn how to take

[moneekak]

You have no idea how helpful this has been for me. I am trying to keep track of my expenses and utilities bills for the last 3 years and I was so overwhelmed. This makes it so much easier to understand. Subscribed and off to check out your other videos ! Thank you for your time

[johnpoe]

A great reminder about how dates in pivot tables changed in 2016.  I don't think I knew the trick to use number formatting instead of "format cell".  A great tip that I'm going to pass on to students in the future.

[cesi]

awesome, I'm really learning a lot from you Mike, i can't stop watching all your video tutorials. Keep it up, thanks so much!!!

[kjvstats]

Masterful as ever, Mike. Data Transmogrification 101 !

[filirojas]

As usual, great learning tool.
Greetings from Tecate, México

[entertainmentgalaxy]

Thanks for sharing.. Beautiful video as always... Please share more PQ videos with amazing tricks..
GBU

[pabloreznicek]

Nice video Mike! I did not know Excel 2016 automatically grouped dates. Has the insert timeline function improved for 2016? I usually work with Walmart weeks and was wondering if eventually the timeline or time periods inside a timeline could be more user defined.

[SantoshLoka]

is there any way to give good protection for excel program there is a 3rd party which can crack my program can yu plz help me out

[karljolivet]

Can you tell me why month is equal to date and not month when grouping?

[masud.md]

In 2010 version it will work properly or Not. May noy working in 2010 plz inform me.