If the Excel Date Filter is not grouping by month, enable grouping dates in the AutoFilter menu, set dates in the proper format, etc.

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.

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

In this article, I’ll show you how to include AND and OR operations in Excel’s FILTER () function. In several spots, you’ll read “AND and OR,” which is grammatically awkward.

How to Make a Cumulative Chart in Excel. By adding all of the data in each of your Excel columns and then creating a chart from the totals of each column, you can generate a cumulative chart in ...

If your company is working with a large list in an Excel spreadsheet, take advantage of the program's built-in filter customization tools to limit the number of rows included in your filter results.