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.

Suppose we want to filter the data set matching the specific criteria, then it can be done using Advance Filter. In this article, I will explain how to use Advance Filter in Excel.

There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.

How to Change Data Organization in Excel. Organize your Microsoft Excel spreadsheet to view your data efficiently. Whether you need to rearrange cells or filter your data to match criteria, Excel ...