How to insert a PivotTable in Excel 2007. Also applies to Excel 2010.
For best viewing make sure you watch the video in 720p HD full screen. To change the settings press Play, the settings will then appear in the bottom right of the video controls, as shown in the orange boxes in the image below.
![]() |
If you need a quick refresher on how to insert a PivotTable you can view my old fashioned written tutorial with supporting images here!
Please tell me what you think of this Excel Pivot Table video tutorial in the comments below (bear in mind this is an extract of Lesson 1 aimed at beginners), and if there’s anything in particular you’d like to learn, please also note it in the comments and I will endeavour to incorporate it in the course.



... I would highly recommend My Online Training Hub for all your Microsoft Office needs .... Geniuses



{ 6 comments… read them below or add one }
The video is not working. Unable to watch the video. Nothing is visible on my screen.
Raju
Hi Raju,
The video is an embedded YouTube video. The video plays fine for me. It may be that you have restrictions on viewing YouTube on your firewall.
Kind regards,
Mynda.
Hi Raju,
As Mynda said its one of our YouTube videos and uses Flash. It may be that your computer doesn’t have Flash installed properly. You can download and install the latest version here http://get.adobe.com/flashplayer/
Or you could watch the video straight off You Tube http://www.youtube.com/watch?v=UoWIhmZj_i4&feature=player_embedded
Or you can try a different browser like Chrome https://www.google.com/intl/en/chrome/browser/
Regards
Phil
Hi Raju,
The video is an embedded YouTube video. The video plays fine for me. It may be that you have restrictions on viewing YouTube on your firewall.
Kind regards,
I am truly amazed at the complexity of Excel and what it will do I can only express admiration for the designers who write the programme as we are only attempting to use a programme they have provided. I find your explanations and presentation first class. I have always been a Paradox and Access user so Excel is another world
Thanks, Keith. Glad you’re finding our tutorials helpful