Array formulas have been available in Excel for decades, but recent enhancements 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. You’ll discover how you can put the power of array formulas to work for you. We’ll begin with an overview of Excel’s “legacy” array features and show you how you can continue to take advantage of these tools. The course then covers the recent enhancements to Excel that facilitate “dynamic arrays” and why these enhancements are so significant. To wrap up the conversation, you’ll review numerous practical examples of dynamic arrays and how you can put them to work for you.