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

 
 
 PivotTable II: Filter PivotTable report data in Excel 2007 
 
  Overview  
 Show/Hide lesson sections See just the data you want to see in PivotTable reports
  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.
Bookmark and ShareShare
Overview
Filter on PivotTable report  

Learn how to filter data in PivotTable reports with Microsoft Office Excel 2007.

Don’t have the 2007 Office release? You can download a free 60-day trial or buy it now.

  • Length: 20–30 minutes
  

Next

GOALS

After completing this course you will be able to:

  • Filter to hide and display selected data in PivotTable reports.
 
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.
AUDIO TEXT

A PivotTable report helps you to see what your data means. You can make the report even clearer by filtering its data. Filtering shows just what you want to look at and hides the rest temporarily.

Learn how to tell Excel 2007 what you want to see, and find out how many ways it can sharpen your vision, 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.

  
BEFORE YOU BEGIN

Complete the course PivotTable I: Get started with PivotTable reports in Excel 2007 or make sure you're acquainted with PivotTable reports in Excel 2007.
  Go to previous page (disabled)    Next Go to next page
advertisement