Click here to go to the Office Update Home page   All Products  |   Support  |   Search  |   microsoft.com Guide  
Featured on Office UpdateMicrosoft
   Home   |    Auto Update   |    What's New   |    Search Office Update   |    eServices   |    Office Update Worldwide   |    Site Help   |
 
  Office 2000  
Download Details
Download Now!
Save to Online Storage
Using: Xdrive

(What's Online Storage?)

Works with
Excel 2000

Filename
xcrtpiv.exe

Filesize
247 kb

Est. Download Time
@28.8
 2 mins

Last Updated
26-Oct-1999

Languages Supported
US English

Return to Catalog
   or Focus Center

 

Excel 2000 Tutorial: PivotTable Reports 101 Click here to email this to a friend.

Let's suppose you've compiled a large list of data - for example, sales figures for every product your company makes. But now you're ready to distill some meaningful information from the data.

For these and other questions, you can create a PivotTable® report - an interactive table that automatically extracts, organizes, and summarizes your data. You can then use the report to analyze the data - for example, make comparisons, detect patterns and relationships, and analyze trends.

This download provides a complete tutorial, including animations, for creating a PivotTable report and modifying it to fit your requirements.


To install this download:

  1. You may want to print this page to use as a reference when you are offline.
  2. Download the file from Office Update by clicking Download Now! at the top left of this page and following the instructions in the dialog boxes.
  3. Double-click the XCrtPiv.exe program file on your hard disk to start the setup program.
  4. Follow the instructions on the screen to complete the installation.

Instructions for use:

To view PivotTable Reports 101, open the folder where you installed the files, and then double-click the file ExCreatePiv1.htm.

To remove this download:

There is no uninstall feature with this download. To remove the download file itself, delete the file XCrtPiv.exe. To remove the files you installed, search for and delete the following files from your drive:

create04.gif
create1.gif
create2.gif
create4.gif
dialog.txt
ExCreatePiv1.htm
ExCreatePiv2.htm
ExCreatePiv3.htm
ExCreatePiv4.htm
ExCreatePiv5.htm
hide1.gif
hide1b.gif
hide2.gif
hide3.gif
off2000logo.gif
page.gif
PivotRptA.gif
PivotRptA.swf
PivotRptB.gif
PivotRptB.swf
PivotRptC.gif
PivotRptC.swf
Print1ab.gif
what3.gif
what4.gif

Sign up for the Microsoft Office Auto Update Notification Service:

The Microsoft Office Auto Update Notification Service is an e-mail list that you can join to find out when new updates are added to the Office Update Web site. The notification e-mail messages contain the name of the update, the download location for the update, a description of the update, and a list of the Office products that will be updated. This is a great way to be notified of critical or helpful Office updates, including additional product functionality or the latest security updates.

For support of this download:

If you are experiencing problems with this download or the Office Update site, please review our Support Page for assistance.

 
    
   é
© 2001 Microsoft Corporation.
All rights reserved. Terms of use.  Disclaimer.