Select Insert > PivotTable. In the Create PivotTable dialogue, in the Table/Range field, select the range of data you want to analyze. In the Location field, select the first cell of the worksheet ...