Array formulas have been available in Excel for decades. But recent enhancements to Excel have breathed new life into this feature. With the new “dynamic array” concept, you can leverage Excel’s array formulas in ways that you may have never imagined possible. Learn how to put the power of array formulas to work for you by reviewing “legacy” array features, recent enhancements to Excel that facilitate “dynamic arrays,” and practical examples of dynamic arrays.