In Excel, you can apply direct formatting to cells' values or backgrounds to make the spreadsheet easier to read. However, when an Excel formula returns a set of values—known as a spilled array ...

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

Microsoft Excel's dynamic array function XLOOKUP() might completely replace VLOOKUP() and HLOOKUP().

Using Excel 2013's Frequency function as an array quickly compiles the frequency data from a list of "bin" ranges. You can then display this data on a bar chart to more readily compare the ...