Microsoft Excel 2000 PivotTable Resource Center

Overview


  • A PivotTable is an analytical tool that summarizes information from particular fields of an Excel list, a relational database file, or an OLAP cube.

    There are several resources available to help you understand how to create and manipulate PivotTables so that your data can be presented in the best possible manner. If you're new to PivotTable creation and usage, start by using the sources listed below. These sources provide information abou the PivotTable design process, common problems with formatting, hot to determine the fields that you may need, and much more.

Step-by-Step Instructions & How To Articles


  • Choose a topic for Step-by-Step instructions on using the features described below.
  • Excel 2000 Tutorial: Pivot Table Reports 101
    For an overview of when to use PivotTables and how to create them, download the above tutorial. This download describes why you would want to use a PivotTable, how to set up your data properly, and how to format the PivotTable after you create it.
  • Improve the Readability of an Excel 2000 PivotTable Report
    If you work with large lists of data, Microsoft Excel PivotTable® reports can help you organize and analyze facts and figures. You can quickly rearrange the data for a different perspective on relationships and trends.
  • New Ways to Automate Corporate Reporting in Microsoft Excel 2000
    Use Microsoft Visual Basic® for Applications (VBA) properties, methods, and objects that allow you to take advantage of new data access methods when you automate queries and PivotTable® reports in custom solutions.

    NOTE: This requires knowledge of programming in VBA and Excel.
  • Ways to Select and Hide Items in PivotTable Fields in Excel 2000
    When a field in a Microsoft Excel 2000 PivotTable® report that's based on source data from an OLAP database has hundreds of items, you need a quick way to select and hide the ones you want. Click the link above to find out how.

Common Knowledge Base Searches

Search the Microsoft Knowledge Base for articles about PivotTables by using the queries below.

Additional Resources & Related Sites

Last Review : July 30, 2009