Page 1 of 16PREVNEXT

PivotTable I: What's so great about PivotTable reports?

Create new views of data with PivotTable reports
Learn about the little-known, yet powerful, Microsoft Office Excel PivotTable feature, which organizes, summarizes, and analyzes your data to reveal its meanings.

About this course

This course includes:

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


After completing this course you will be able to:

  • See why the PivotTable feature is so useful.
  • Make sense out of data by creating a PivotTable report.

Do you have more data than you know what to do with? Do you want to see trends and patterns at a glance? Then PivotTable reports are for you. They enable you to create new views of worksheet data in seconds. Hundreds or thousands of pieces of information swing into place, revealing the meanings behind the data. In this short course you'll learn how PivotTable reports can benefit you, and you'll actually, quickly make a PivotTable report.

To learn more about this course, read the overview in the center of this page or the table of contents in the left column. Then click Next to start the first lesson.

Page 1 of 16PREVNEXT