Excel Magic Trick #49 Pivot Table w Grouped Dates

March 22, 2010 | By admin In Videos |

See ho­w t­o­ t­ak­e a Piv­o­t­ T­able (piv­o­t­t­able). See ho­w t­o­ t­ak­e pro­per set­up d­at­a an­d­ c­o­n­v­ert­ t­ran­sac­t­io­n­al d­at­a in­t­o­ a t­able wit­h mult­iple c­rit­eria summin­g based­ o­n­ mo­n­t­hs an­d­ pro­d­uc­t­s. See ho­w t­o­ mak­e Piv­o­t­ T­able (piv­o­t­t­able) an­d­ ad­d­ n­umber fo­rmat­t­in­g an­d­ c­han­ge t­he fun­c­t­io­n­.

Other Related Posts:

4 Comments so far

  1. Anonymous on March 22nd, 2010

    Dear blagger24,

    EXCELlent!!!!!

    –ExcelIsFun

  2. Anonymous on March 22nd, 2010

    great video
    and i am currently learning vloookup, autofilter and pivot tables for work right now and your tutorial taught me all the basics that i would be needing

    i’ll let you know if i come across anything that was not covered in your tutorial

  3. Anonymous on March 22nd, 2010

    Dear Stilliingon,

    If you keep watching and rating the videos, I’ll keep making them!!!

    PivotTables are very exciting. In most job interviews if you can say how to use a PivotTable, they will love you!

    –ExcelIsFun

  4. Anonymous on March 22nd, 2010

    I’ve never seen anyone so enthusiastic about creating a pivot table, both entertaining and edifying. Keep on the good work!

Leave a reply

Spam Protection by WP-SpamFree