Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

Not everyone is familiar with Excel. You can protect the data input process by using Excel's UserForm object to collect data. Susan Harkins explains how.

An Excel filter selectively displays rows that meet specific criteria, making it easier to analyze large datasets. We'll show you an easy way to do that, as well as how to use advanced filters and ...

Create a UserForm containing a dynamic number of controls and make sure they are being triggered by certain events. To achieve this result, we will use a UserForm and a class module, and assign any ...

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

Filtering in Excel allows you to organize your data in multiple ways. Using a filter, you can cut down the amount of data shown on your sheet based on the values for either a certain selection ...

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

How to Subset Data in Excel. Filters are used to create subsets of data in a Microsoft Excel worksheet. The "AutoFilter" or "Sort and Filter" function in Excel allows you to create views of data ...

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