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.

You can't use a SUM() function to sum a filtered list, unless you intend to evaluate hidden and unhidden values. Here's how to sum only the values that meet your filter's criteria.

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

Filtering unique values and deleting duplicate data is a basic operation that everyone needs to know when using Excel. Join us to learn how to do that on Excel for Office 365, Excel Online, Excel 2007 ...

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

Were you wondering about how to count unique values in Excel? We've got you covered with our guide that have everything you need to know.