When I first discovered Excel's dynamic array functions, my entire approach to spreadsheet design shifted. They replaced my clunky, multistep workarounds with smart, self-expanding formulas that adapt ...

Don't copy formulas cell by cell — you're working way harder than you need to.

The AGGREGATE function in Excel is a versatile feature designed to perform calculations like sums, averages and counts while selectively ignoring elements such as hidden rows, errors, or filtered-out ...

Excel doesn’t have a built-in AVERAGEIF() function, but you can still average values, conditionally. Excel has SumIf and CountIf, but no AverageIf. However, with a little array magic, you can get ...

Navigating the world of Excel can sometimes feel like trying to solve a puzzle with missing pieces. If you’ve ever found yourself wrestling with the XLOOKUP function, only to be met with a chaotic ...

In addition to the new SORT function, you may also find the new FILTER and UNIQUE array functions useful. For example, the worksheet on the next page contains a detailed listing of invoices in columns ...

Lists are the most straightforward part of the rollout. A user can create one through Insert > List or by pressing Ctrl+J, then add items separated ...

Microsoft is changing one of Excel’s most familiar rules: a cell no longer has to contain just one value. The company has introduced lists, arrays in cells and nested arrays, giving users new ways to ...