How to Work With Pivot Tables in PPT Excel 2003

1. Launch Excel 2003 and open a blank spreadsheet. Enter the source data that you want to use for the pivot table. The list should be organized in to columns or rows with original headers that correspond with the data that follows. For example, headers for a list of families who live on specific streets would be stored in the spreadsheet using the street names as column headers and the family surnames in the corresponding cells in the appropriate columns.
2. Click the “Data” menu and select the “PivotTable and PivotChart Wizard” option, which will open a separate window. Click the “Microsoft Excel” and “Pivot Table” options and click the “Next” button.
3. Select the data that you entered by clicking the header in the first column and dragging to the last cell in the last column while holding down the mouse button. Click the “Next” button.
4. Click the “New worksheet” option to display the pivot table results in a new worksheet within the Excel workbook. Click the “Existing worksheet” option to display the results in the worksheet that contains the source data. Click the “Finish” button.
5. Select the data that you want to appear in the PPT file. Click the “Copy” button. Launch PowerPoint 2003 and open a blank slide show or a presentation to which you want to add the pivot table information. Click the “Paste” button in PowerPoint to paste the data into the slide.