Désolé... Cet article n’est pas disponible dans votre langue.

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.

Start course button

About this course

This course includes:

  • One practice session for hands-on experience. The practice requires Excel 2007.

  • A Quick Reference Card you can take away from the course.


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.

Topics in this course

  1. Work with numbers

  2. Summarize data another way

  3. Perform a custom calculation

  4. Who gets a bonus?

  5. Practice

  6. Quick reference card

Partager Facebook Facebook Twitter Twitter E-mail E-mail

Ces informations vous ont-elles été utiles ?

Très bien ! Vous avez d’autres commentaires ?

Comment pouvons-nous l’améliorer ?

Nous vous remercions pour vos commentaires.