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.

If you know how to use filters already in Excel, you can apply the same techniques to pivot tables. Click the little box with the filter icon in any row or report filter cell and you can filter ...

Excel's GROUPBY function lets you group and aggregate data based on certain fields in your table of data. It also offers arguments that allow you to sort and filter your data, so you can tailor the ...

You've probably heard of pivot tables and just kind of ignored them, since they sound pretty complicated and it's not even clear what they do. The reality is that you can create pivot tables from ...

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.

A few months back, Dave showed you how to use Excel pivot tables to better visualize your spreadsheet data. (If you missed the post, be sure to check it out -- it has video!) Of course, if you've ...