AMLAN BASU AUDITOR

  Create a PivotTable in Excel for Windows Select the cells you want to create a PivotTable from. Note:   Your data should be organized in columns with a single header row. Select  Insert  >  PivotTable . This will create a PivotTable based on an existing table or range. Note:  Selecting  Add this data to the Data Model  will add the table or range being used for this PivotTable into the workbook’s Data Model.  Learn more . Choose where you want the PivotTable report to be placed. Select  New Worksheet  to place the PivotTable in a new worksheet or  Existing Worksheet  and select where you want the new PivotTable to appear.  Click  OK PivotTables from other sources  By clicking the down arrow on the button, you can select from other possible sources for your PivotTable.  In addition to using an existing table or range, there are three other sources you can select from to populate your PivotTable. Note:...