If you use Google Sheets regularly and want to refer to an abbreviated version of your data, then look no further than the pivot table. Here's how to use it.

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.

Learn how to create a pivot table in Google Sheets. A pivot table is a statistical tool that allows you to summarize or aggregate data sets.

Pivot tables are like the Swiss army knife of data analysis in Excel. And trust me … They look scary at first, but they’re so easy to use once you learn the underpinning logic that powers them.

For starters, instead of manually creating a pivot table to bring order to your data set, Google Sheets can suggest a pivot table based on the data you have in Google Sheets for you automatically.

You can use VLOOKUP with Google Sheets similar to how the search function is used to find information in Excel.