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

Master Excel’s FILTER function to simplify data filtering, save time, and tackle complex datasets with ease. Learn advanced techniques now!

If you are unfamiliar with inputting formulas into Microsoft Excel, the much simpler way to get the number of unique values in an Excel column is through a filter.

Learn how to use Excel FILTER, XLOOKUP, and SUMIFS functions to streamline workflows and make smarter data-driven decisions.

Filter by Multiple Colors in Excel. Filtering is a very important feature in Office Excel 2010, the spreadsheet software from Microsoft, because it enables you to view only rows that contain data ...

Easy one for the Excel Gurus (best way to filter/sort unique item counts from a column of mixed string formats) sixstringedthing 17 minutes ago Jump to latest Follow Reply S ...

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

If you need to average a list of values in Microsoft Excel that contain duplicates without including the duplicates, don't fret over a complex expression when you can easily remove those duplicates.