﻿ Pivot Table Tutorial in Excel 2007 - What it is and How to Use it
MS Office Training
 Excel Tutorial Excel Formulas Microsoft Word Training

Typing Training
 Typing Games For Kids Typing Tutorial Typing Test

Math Games
 Math Games Place Value Probability

Spelling & Vocabulary
 Spelling Games Crossword Puzzles Word Search

Grammar & Writing
 Learn English Grammar Creative Writing Course

Life Skills for Kids
 Good Study Habits Goal Setting Financial Literacy

Relaxing Mindfulness

Website Info
 Excel Basics Formulas & Functions Special Features Format Cells Sum, Average, Countif Functions Excel Charts (Graphs) Worksheets Quick Functions Excel Sort Edit Cells The IF Statement Excel Filter Rows and Columns VLOOKUP Function Conditional Formatting Find and Replace Sumif Function Pivot Table The Fill Handle Excel Formulas Create a Drop Down List Excel Keyboard Shortcuts First Aid

# 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…