Excel pivot table video tutorial. But basically all you need to know is that something that would typically take a long time can be done quickly and painlessly when you build a pivot table. Ideally you can use an excel table like in our example above. This is an introduction to using pivot tables or pivottables in microsoft excel. Learn how to create pivot tables in excel and how to use them to draw out the information you want to see.
It works in excel 2003 2007 2010 and 2013. Check out this video to see all of the different capabilities of an excel pivot table. Excel pivot table video tutorial january 21 2011 by mynda treacy 19 comments an excel pivot table is one of the most powerful productivity tools available but some common data layout mistakes can make pivot tables difficult frustrating and downright scary for some users. Pivot tables are intimidating to many excel users.