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

This newish function is available in Microsoft 365 and Excel 2021, and Excel for the web. For your convenience, you can download the demonstration .xlsx file.

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 ...