Welcome to PC Teach Me...

Free Computer Training Videos.

Although you do not need to register to access this site. Registering has its benefits. Such as:

  • Access to training material associated with the video you are watching [if applicable]
  • Automatic email updates when new training videos are available.
  • Ask for a training video.
  • Exclusive access to pose questions to me [limited availability as I am doing this for free :-)].
  • Free contribution of your own training topics, this includes referencing your videos outside of PC Teach Me.
  • Its Free!

Member Login

Lost your password?

Not a member yet? Sign Up!

By registering with this blog you are also agreeing to receive email notifications for new posts but you can unsubscribe at anytime.

25425 Registered Users
71 Number Of Articles
Free Video Tutorials (Email) Free Video Tutorials (RSS) Free Video Tutorials (Twitter) Free Video Tutorials (Flickr)

Excel: Pivot Tables

Part of Microsoft Excel Basics

Excel Excel: Pivot TablesExcel: Aggregating tables by means of a Pivot

One thing I do find funny in my line of work is the amount of IT people that don’t use Pivot tables. Pivot tables can save the user so much time when it comes to querying large amounts of data. The premise is simple; I have a large list of data, I want to inspect it and create summaries. That’s what they are all about, what I find is when people hear the term “Pivot Tables” they get scared!

Excel Pivot tables

In my training days I used to calm people down and show them the power in 10 minutes and hey guess what! That’s what I will try to do here!

I will say that I think Microsoft have jumped the shark a little bit on the new version of Excel, as what was once a simple joy to use has become extremely complicated. I understand the reasoning for it as Excel is Microsoft’s strategic BI platform for cubes coming from Analysis Services for users to perform ad-hoc querying of massive amounts of data. However, I think that putting a complex face on something as cute as Pivot tables is the same as putting a Freddy Kruger mask on a cute little kitten!  Basically, the new layout deters new users from using them. I pride myself on my knowledge and the new version took me quite a while to get to grips with (maybe I am getting old!)

Anyway, from reading this you may thing I am anti-Pivot table, I’m not, it’s just they have focused on making Pivot Tables so complex that they forgot about the user.  I have aimed this video for all users of Excel, so the way I tackle this subject is not how I would normally do Pivot tables in Excel 2007, but have opted to use an approach which works regardless of version.

So I hope this video will make sense of its core features (not all by a long shot) and allow you to take control of your data.

This video is one of many Excel tutorials on this site click here for more.

Example Excel File

Included in the video is an Excel File which you can download from here:

I recommend you download this Excel file as this will give you something to play with and there are loads of possibilities to try

Related Posts

10 Comments

  1. excel used says
    27 Jan 14 at 9:30pm

    I don’t see the link for downloading the data. I really like how your explaining it, but I can’t really understand until I actually do it. Please let me know where the link to download the file is.

  2. madndlusa1 says
    21 Mar 13 at 11:54am

    copied comment from another “Excellent tutorial. Quick, simple and to the point!”, could not say it better, thanks

  3. kerl says
    31 Oct 12 at 1:12pm

    Thanks for the video. How can I register to download the excel file ?

  4. bcwu3628 says
    02 May 11 at 11:11pm

    Excellent tutorial. Quick, simple and to the point!

  5. PCTeachME says
    18 Apr 11 at 12:17pm

    @neogutsman Thanks for taking the time to respond. Oh yes Excel is a massive tool suitable for Accountants and NASA Sciencetists. Excel is something I use everyday but find difficult to provide videos on.  If there is something in particular you want to know…send me a message.

  6. neogutsman says
    17 Apr 11 at 12:18am

    Just wanted to say thank you ever so much for this informative and succinct tutorial on pivot tables. Excel is an amazing tool, but it can be incredibly challenging to learn how to take advantage of its functionality. Keep up the great work!

  7. brolicom says
    01 Apr 11 at 4:19pm

    Helpful to learn unkown features of Excel. Regards from Buenos Aires, Argentina.

  8. easye says
    23 Mar 11 at 10:52pm

    Very helpful! thank you!!
    Only issue I had was trying to follow along while using my Excel 2008 for Mac version :)
    But with some keywords and concepts, should be able to handle the differences.

    cheers from Vancouver, BC!

    eric

  9. PCTeachME says
    08 Sep 10 at 10:56am

    @patwalpriya Hi there!
    Thanks for the feedback. On my site (PCTeach.me) Excel is the least covered area, which I am in the processes of rectifying. If there is something of interest you would like to know. Now is the time to ask and put your request to the top of the pile!

    Thanks!

    Jon

  10. 08 Sep 10 at 9:46am

    Great Video..
    Thanks for all the help… it definitely added to my understanding of MS Excel.
    Easy to understand and very smoothly explained.
    Good goin!!!

Leave a Comment

You must be logged in to post a comment.

Valid XHTML 1.0 Transitional website security