↩ Back

Using and Creating Pivot Tables in Excel 2007 - A Tutorial For Dummies

The following videos will teach you how to use them from the very basics: How to set up the working environment and make your first steps, basic concepts, useful features, and advanced usages. The last video gives you tips on how to improve their appearance.

1. Getting into the Pivot Table Environment 2. First Simple steps with Pivot Tables 3. Useful Features of Pivot Tables 4. Getting Advanced: Intersecting More Than One Field 5. Improving the Appearance of the Pivot Table, Making it More Comprehensible
What is a Pivot Table? - Examples

(I would highly recommend that you go over the tutorial videos in the order they appear - starting from the top downwards, because every video is advancing a step further the concept taught in the former one).

What is it? Well, it might be just the most powerful and efficient feature of Microsoft Excel.

With it you can summarize a table’s data by its different fields (the table’s columns), and to easily make all the desired intersections between them.

For example, if you are given a table of company employees with the following fields:

- Employee name
- Department
- Car ownership
- Salary
- Number of monthly working hours


You can easily use a pivot table to retrieve the following information:
- Count the total number of employees in every department.
- Count the total number of employees with and without a car.
- The average salary of employees with a car, and of employees without a car.
- The average salary of employees with a car and without a car, inside every department.
- The highest number of monthly working hours for every department.
…and the combinations are endless.

You can find such examples in the videos presented above. They are demonstrating the subjects in a step-by-step "pivot tables for dummies" manner.

After creating it and getting the basics, you can go ahead with using advanced features: format it, sort it, group dates and numerical ranges together, filter items outside, switch between rows and columns, apply different statistical functions to the data (sum, count, average etc.), change and refresh the original data and see how it is reflected on the report, create a chart from it …and this list can go on…