What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter, format ...

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.

Learn how to use filters and sorts to identify and fix data errors in Excel, such as blanks, errors, outliers, duplicates, and inconsistencies.

Microsoft Excel’s Advanced Filter feature displays records that match specific criteria. You can also limit the columns returned by this feature.

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.