In the Create pivot table dialogue box, specify where you’d like to insert the pivot table, and then click on the Create button. You can insert it in the existing worksheet or in a new worksheet.

A pivot table is a useful tool in data analysis that can give you an overview of your data. We'll show you how to create one in Excel and Google Sheets.

Select New sheet to make a cleaner presentation. When you select Existing Sheet, specify the cell you want to be the upper-left cell of your pivot table. Click Create.

Pivot tables in Google Sheets summarize smaller sets of data from a more extensive dataset and can be sorted by rows, columns, values, and filters.