Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
 PivotTable I: What's so great about PivotTable reports? 
 
  Overview  
 Show/Hide lesson sections Make your data work for you
 Show/Hide lesson sections Create a PivotTable report
  Feedback  
 Quick Reference Card Quick Reference Card  
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Overview
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.

  • Length: 20–30 minutes
  

Next

GOALS

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.
  
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.
COURSE TEXT

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.
  Go to previous page (disabled)    Next Go to next page
advertisement