Claim this complimentary eBook worth $50 for free, before the offer ends on Sep 16.

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.

You can create pivot tables in Google Sheets manually or automatically and sort your spreadsheet's data by rows, columns, values, and filters.

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

VIDEO: Pivot tables are easy to create and invaluable if you have a lot of data to sort through.

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

Pivot tables may be powerful, but they are a real pain to sort and analyze like we did at the beginning. In fact, trying to sort can cause your pivot table to get a little funky.