This training focuses on using dynamic arrays with Excel functions available in Microsoft 365. We will show you how to leverage the power of dynamic arrays to create more efficient and dynamic reports. Thus, analyzing complex data becomes accessible to everyone. You will be able to create reports that seem very complex to set up, but that you can design using simple functions. The introduction of dynamic arrays represents the biggest change in Excel in years.

Technical precision: You must have the Microsoft 365 version of Excel.