Click Here to Install Silverlight*
United StatesChange|All Microsoft Sites
Microsoft
Download Center 
Search Advanced Search

Excel 2000 Tutorial: PivotTable Reports 101

Brief Description
A complete tutorial, including animations, for creating a PivotTable report and modifying it to fit your requirements.

On This Page

Quick Details
File Name:XCrtPiv.EXE
Version:2000
Date Published:10/26/1999
Language:English
Download Size:247 KB
Estimated Download Time: 1 min 56K

Overview

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.

 Top of page

System Requirements

  • Supported Operating Systems: Windows 2000; Windows 95; Windows 98; Windows NT
  • This download works with the following Office applications:
    • Excel 2000

 Top of page

Instructions



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 this page by clicking the Download button above 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

 Top of page

 Top of page

 Top of page


© 2010 Microsoft Corporation. All rights reserved. Contact Us |Terms of Use |Trademarks |Privacy Statement