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.

Microsoft Excel's new dynamic array functions make complex calculations easier than ever before.

Excel's SEQUENCE function lets you create a list of numbers in a sequence in an instant. It also allows you to define the shape, number of values, and steps between each number in the sequence ...

For Excel 365, formulas that return a set of values (or an array) are able to spill. Therefore, you can have your formulas spill when using simple calculations, as we did here, and also when using ...