Beginners Guide to Pivot Tables

Thanks! Share it with your friends!

Close

Pivot tables are one of the most powerful and most underused features in Excel. The interface has been reworked in Excel 2007/2010 and this video show how to create a Pivot table in Excel 2010.

What you will see in this video is that pivot tables are quick and easy to do and use no Excel equations at all.

I added this video on the because it is only 5 minutes long and it shows two really cool features of pivot tables – the first is that it groups date data by day month year automatically and the second is that if you do not define a row heading you can use Pivot tables to count or sum data based on one or more conditions without any equations – I use this technique all the time.

This video has been supplied by our friends at

ImproveYourExcel.com viewers can take advantage of lots of free videos on their site and a special reduced offer for 3 months access to their comprehensive Excel 2007 and 2010 course – with an amazing 197 Videos online!

Click here for more information and register to receive more free training and access to their special offer.

Comments

khumbah says:

This wonderful am going to try this as i work along. thanks

Write a comment

*

 
  Advertisement
Skip Ad
Skip Panel
 
Skip Survey
Test
Name
Email
×
It would be awesome to hit "like" or "share" and start playing.