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 ...

Create your pivot table using your entire or selected data range in a new or existing sheet. In the left side column that appears, look underneath Suggested for a small list of potential pivot ...

In Excel, you can create relationships between two tables based on the matching data within the table. Learn how to create relationships between tables in Excel.

The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables ...

In this tutorial, I’ll show you how to create a date table when the internal default table isn’t adequate using Data Analysis Expressions.

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.