×
英文
很抱歉,此文章目前沒有您所使用語言的版本。

PivotTable II: Filter PivotTable report data in Excel 2007

Filter on PivotTable report

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

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.

Goals

After completing this course you will be able to:

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

Topics in this course

  1. See just the data you want to see in PivotTable reports

  2. Filter to see one product out of many

  3. Narrow the filter to see a single item

  4. Set a value filter to view products by specifying amounts

  5. Set a date filter to see data for a selected time

  6. Remove filters

  7. Practice

  8. Quick reference card

這項資訊有幫助嗎?

我們應該如何改進?

我們應該如何改進?

若要保護您的隱私,請不要在意見反應中包含連絡資訊。 檢閱我們的 隱私權原則

感謝您的意見反應!