Dynamic arrays change the rules for formula output in Excel. When I write a formula that returns a list by default, I need to decide whether I want the result to spill across a range of cells or ...

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. Filtering is a huge part of many Microsoft Excel sheets, and ...

I've written many times about the many benefits of formatting your data as a structured table in Microsoft Excel. However, despite this, there's one major issue that continues to throw a spanner in ...