Excel's Subtotal command allows you to quickly create subtotals in your sorted data, and then collapse the view to to show only the new subtotal rows.

There are several reasons to use SUBTOTAL instead of SUM when inserting subtotals in your spreadsheet.

Pivot tables generate great reports in Microsoft Excel, but adding a filter or two can make them even more flexible. Here's how.

Placing spreadsheet data into a table quickly formats it and makes it easy to work with and analyze. Here’s how to use this basic yet powerful Excel tool.