Creat a PivotTable that allows you to sort and filter only the data you need from large amounts of data.
By default, the data area you have select is diaplayed in the input box.
Select New Worksheet, and then name the worksheet.
Select the source data area from which you want to create a PivotTable.
Create a new worksheet with a PivotTable inserted. By default, the new worksheet is named “Sum 1” and can be edited.
Specify a location to insert a PivotTable on the current workbook. You can enter the cell address directly, or click the area selection button to drag the cell location to select it.