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.

The Problem: Dynamic Array Formulas Don't Work in Excel Tables A dynamic array formula is a formula whose result spills over from one cell to other cells. What's more, if the result of the formula ...

Excel has announced a new array-based function called SORT, which can be used to sort data in one or more columns without involving a manual sort process or a complicated macro process.

Learn how to fill blank cells in Excel effortlessly with dynamic array functions like SCAN, REDUCE, and LAMBDA. Handle Excel blank cells with ...

Microsoft 365's UNIQUE() function is a great reason to upgrade. Combine UNIQUE() and SORT() to generate unique lists with a single formula.

If you want to link multiple cells from another worksheet, you can use an array function, which lets you link a range of cells using one formula.

One of the most powerful features of Excel is the array—a formula designed to act simultaneously on sets of two or more values in order to calculate other values. Yet, because arrays appear to be ...

However, rather than manually entering a formula for each cell in your Excel spreadsheet, you can create an array from multiple rows.

A Microsoft Excel spreadsheet is among the most versatile business tools. Here’s a full guide on how to create a simple and effective Gantt chart in Excel.