Excel Tutor - Cyprus

Pivot Table Reports

This lesson explains how to create Pivot Reports. The following areas are covered:
1. Using the Pivot Table Wizard.
2. Changing the order of the fields.
3. Formatting the numbers.
4. Changing the position of fields.
5. Creating calculated fields.
6. Explaining how to add a field which shows the Percentage of total of a field.
7. Using AutoFormat.
8. Grouping Data.
9. Creating Pivot Chart Reports.

Pivot Table Reports - Examples


The Pivot Table tool is used to summarize lists and it is perhaps the most powerful utility of Excel.

The illustration below shows a database, which consists of 371 Rows (The same database is used when illustrating Subtotals and Filtering techniques). The next two figures are a Pivot Table Report and a Pivot Chart Report created from this data. Click here to see how they are created.

Database used in the Examples Download it here

The drop down arrows shown above allows the user to hide some records from the reports. For example the ticks on the three of the four regions can be removed in order to produce reports for a specific region. In this way the regional manager will not see the results of other regions.

Home | Who Am I? | My Training Program and Examples

| Downloads | Links | Contact