You can sort data from largest to smallest or vice versa, making it easier to spot trends or outliers that might otherwise go unnoticed.

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

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

To display specific values in a PivotTable in Microsoft Excel, use one of the many built-in filters, such as Top 10.

Creating the table Now, select the data. Using Excel, this is as simple as clicking and dragging over the data. Now select the 'Insert' tab and then 'Pivot Table'. It is best to insert the table into ...

You can filter data in Excel based on either certain parameters in columns or over the whole sheet, and you can later unfilter the sheet.