Step 3b - Layout - This is not a separate step in the Wizard as it can either be done before or after the pivot table has been created. Step 3 - Location - Lets you decide whether to display the pivot table report on a new worksheet or on the existing worksheet If the insertion point is anywhere within the Excel list or database then the whole block of cells will be selected automatically. Step 2 - Source Data - Lets you select the cells and define the range to use for the source data. Step 1 - Type of Report - Lets you choose where the data is coming from either an Excel list or database, external source, consolidation of ranges or even another pivot table. The pivot table wizard will take you through the three stages. There are three steps allowing you to change the type of report, the data to use and the location of your pivot table. Pivot Table Report - Starts the Pivot Table and Pivot Chart Wizard, which guides you through creating or modifying a PivotTable or PivotChart report. You can display the Pivot Table wizard by selecting (Data > PivotTable and PivotChart Report).
0 Comments
Leave a Reply. |