Excel Slicers are easy to use visual controls added to Excel that allows to quickly and easily filter data in an interactive way by selecting values from a list.

There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.

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