This month, Susan Harkins introduces an Excel user to advanced filtering and helps a PowerPoint user reduce his work when positioning pictures in PowerPoint.

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

When an ordinary alphabetical or numerical sort in Microsoft Excel won't do, check out the advanced sorting options or add a custom sort pattern.

If Excel filter is not working after certain row, for merged cells, on large files or on protected sheet, then see this post.

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

The Excel AutoFilter feature allows you to narrow your data based on certain criteria and extract records that match those criteria. To turn on a filter, select the cells with data that you want to ...

Learn powerful filtering options with Excel's advanced filters. They're regex on roids!

For a more advanced filter, point over "Text Filters" or "Number Filters" to open the submenu, and then select the preferred sorting options.

In this case you need to use Excel’s Advanced Filter options. You need to have at least three blank rows above your data range. Copy the column names to the first blank row so they are an exact match.