Array formulas are a long-standing feature in Excel. But recent enhancements to Excel have breathed new life into this feature. With the new “dynamic array” concept, you can leverage Excel’s…
Tag: Filter
Managing Slicer Filters In Power BI
If you are working with Power BI, you probably already know how powerful Slicer filters are. In this tip, you will learn how to manage your Slicers for even more…
Rethinking Sorting And Filtering in Excel
When sorting or filtering data in Excel, most users instinctively click the drop-down arrows at the top of a column to initiate the process. In this tip, you will learn…
Excel's New Dynamic Array Feature
Excel’s New Dynamic Array Feature Excel’s new dynamic array feature is one of the best enhancements Microsoft has added to Excel in years. With dynamic arrays, we now have the…