8-ning Sahifa 1OLDKEYINGI

PivotTable III: Calculate data in PivotTable reports in Excel 2007

Numbers and a PivotTable report
Work with numbers in PivotTable reports in Microsoft Office Excel 2007 to help you see what your data means.

About this course

This course includes:

  • One self-paced lesson and one practice session for hands-on experience. The practice requires Excel 2007.
  • A short test at the end of the lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.

Goals

After completing this course you will be able to:

  • Summarize data by using summary functions other than SUM, such as COUNT or MAX.
  • Show data as a percentage of the total by using a custom calculation.
  • Create your own formulas in PivotTable reports.

Before you begin

Complete the course PivotTable I: Get started with PivotTable reports in Excel 2007 or make sure you're acquainted with Excel 2007 PivotTable reports.


Excel automatically adds up numbers in PivotTable reports using SUM, which is called, naturally enough, a summary function. You can use other summary functions to calculate the numbers in different ways: for example, to get the average, or to count things up.

Or you can show values as a percentage of the total, or create a running total, by using a custom calculation. And you can create your own formulas in PivotTable reports.

Learn how to work with numbers in PivotTable reports in this brief course.

To learn more about this course, read the text in Goals and About this course, or look at the table of contents. Then click Next to start the first lesson.

8-ning Sahifa 1OLDKEYINGI