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.

How to use the newish XLOOKUP() dynamic array function in Excel Your email has been sent Image: 200dgr/Shutterstock Must-read Windows coverage CrowdStrike Outage Disrupts Microsoft Systems Worldwide ...

Microsoft has been adding new features to Excel lately, and the latest one could change the way people work with formulas.

Excel running totals made easy with dynamic arrays. Explore advanced functions for accurate, flexible data handling and improved performance.

An curved arrow pointing right. {} These brackets mean something magical is happening inside your Excel formula. An "Array" function allows you to perform mathematical operations on many cells ...

Array: An array, an array formula, or a reference to range of cells to which you want the number of rows. How to use the ROW function in Microsoft Excel Launch Microsoft Excel. Type into the cell ...