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

One way to display figures in an Excel table according to certain time periods is by using filter buttons. However, a better way to do this is to use a timeline, a dynamic filter option that ...

When the filtered set has multiple records, you might want to sort the results using SORT () How to add the SORT () function in Excel The SORT () function is another new dynamic array function.

Learn how to filter data using wild cards and other complex criteria using Advanced Filter in Excel.

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.