Creating a Pivot Table in Google Sheets

The steps to create a Pivot Table in Google Sheets and Excel will vary slightly. In fact, creating a Pivot Table in Google Sheets will be more complex and challenging.

Guidance on creating a Pivot Table in Google Sheets

1. What is a Pivot Table?

As mentioned by Mytour above, Pivot Table is designed to analyze and summarize large volumes of data, providing users with a visual understanding and quicker insight into spreadsheet data.

2. How to create a Pivot Table on Google Sheets

To create a Pivot Table on Google Sheets, follow the steps below:

First, proceed to open the spreadsheet containing the data you want to create a Pivot Table on Google Sheets.

On the spreadsheet, select the cells you want to use in the Pivot Table. If selecting the entire spreadsheet, you can skip this step.

Note: Each selected column must have a linked header to create a Pivot Table with those data points.

Next, on the Google Sheets menu bar, find and click Data (dữ liệu) =>Pivot Table.

At this point, the screen will display the Pivot Table creation window. Here, under the Insert to section, you can choose New Sheet to insert the Pivot Table into a new sheet or Existing Sheet to insert it into the current sheet.

If you select the Existing Sheet option, you'll need to proceed with selecting the location to add the table.

Once completed, click on the Create button to generate a new Pivot Table.

Note: In case the new Pivot Table doesn't open automatically, click on Pivot Table located at the bottom corner of the spreadsheet.

3. Editing Pivot Table on Google Sheets

In the Pivot Table window, on the right-hand side, you'll find a window for editing the Pivot Table. Here, there are options allowing you to add rows, columns, values, and filter data.

Choose any option in the Suggested section and click on the Add button next to it. Google Sheets will automatically generate your summary table using the selected options from the list.

To customize the Pivot Table according to your preferences, click on the Add button next to any option. Here's how:

Rows: Add all unique items of a specific column from the dataset to the Pivot Table as row headers.
Columns: Add selected data points (headers) as summaries for each column in the table.
Values: Add the actual values of each data point (or header) from the dataset for you to sort on the Pivot Table.
Filter: Add a filter to the table to display only data points that meet specific criteria.

Click on the Add button next to the Rows option and add the rows you want to display in the Pivot Table as shown below:

Next, click on the Add button next to the Values option and insert the values you want to arrange the information by.

To adjust the values, simply click on the dropdown menu icon in the Summarise by section and select any option including SUM, COUNT, AVERAGE, MIN, MAX, ... .

Furthermore, if desired, you can create your own formula by clicking on the Add button next to the Values option and choosing Calculated Field.

Enter any formula you wish to use in the box under the Formula section:

Lastly, to add a filter to the table, click on the Add button next to the Filters option.

When adding a filter, you can choose to select or deselect the values you want to display on your table, then click on OK to apply the changes.

Here, Mytour has just guided you on how to create a Pivot Table on Google Sheets. Wish you all success.