EXCLE 透视表制作（EXCLE perspective watch）.docVIP

EXCLE 透视表制作（EXCLE perspective watch） EXCLE PivotTable production Create data First, create data in the Excel worksheet. You can import data from an existing spreadsheet or database into the new Excel worksheet. Ensure that data is available for pivottable: 1. delete all empty lines or empty columns. 2. delete all automatic subtotals. 3. make sure that the first line contains descriptive captions for each column. 4. make sure that each column contains only one type of data - for example, a column is text, and the other column is numeric. Start the PivotTable and PivotTable wizard 1. in the Excel worksheet, select a cell from the table in which it creates the pivottable. 2. on the data menu, click PivotTable and PivotTable to start the PivotTable and PivotTable wizard. What if you cannot select a PivotTable and a PivotTable? If workbook is shared (shared Workbook: allows multiple users on the network to view and edit workbooks at the same time. Each user who saves the workbook can see the changes made by other users The PivotTable and PivotTable command is not available. 3. under the PivotTable and PivotTable wizard, 3, step 1, please specify the data source type to be analyzed data: click the Microsoft Office Excel list or database. 4. click the PivotTable under the type of report you want to create. 5. click finish. Excel inserts a new worksheet in your workbook that contains the layout area of the report (that is, the PivotTable toolbar) and the PivotTable field list. Begin building your PivotTable report Drag the class field from the PivotTable field list to the row row field of the PivotTable to this area. Dont worry about putting the fields in the wrong place and you can move them at will. Notice that the wizard populates the rows automatically with data from the category column in your worksheet. In addition, the fields used in the PivotTable field list are shown in bold type. PivotTable in the row for the category What if you dont see the PivotTable field list