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

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.

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

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

Learn how to define, use & delete names in Excel formulas. It becomes easier to identify & comprehend data when you can add Names to it.