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.

How to make your first pivot table To start, navigate to Google Sheets and open the spreadsheet you want to work on. This example uses a coin collection because that's more interesting than ...

Learn how to use data validation in Google Sheets to enter information faster and with fewer errors.

What is a Named function in Google Sheets? Named functions are similar to Google Sheets' built-in functions. The difference is that you create them and define what they do.