Microsoft Excel's new dynamic array functions make complex calculations easier than ever before. Image: PixieMe/Shutterstock Microsoft 365 updates the way Excel handles dynamic functions.

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Learn how to calculate moving averages in Excel using dynamic arrays. Simplify rolling totals with custom functions for efficient analysis.

INDEX with XMATCH returns an item from a range or array according to the first or last match it finds. Like XLOOKUP, it works with vertical and horizontal datasets, can search in any direction, and ...

Learn how to create interactive dashboards and dynamic workflows in Excel using modern functions like SUBTOTAL, AGGREGATE, and SWITCH.

If you are routinely creating formulas that accomplish the same purpose, spending a little extra time upfront to create a function that can be reused will save you time in the end, possibly a ...

In Excel, custom input or error messages explain the rules for each field to prevent data-entry errors. Here's how to set them up in a spreadsheet.

Are you wondering how to use the Excel FILOTER function with multiple criteria? We have detailed guide on how to easily use the Filter function in Excel using the AND and OR operators.