Dynamic Arrays in Excel

Dynamic Arrays in Excel is a focused 55-minute course that introduces the powerful array formulas available in Excel 365, including XLOOKUP, FILTER, UNIQUE, SORT, SORTBY, SEQUENCE, and RANDARRAY.

This course is designed to introduce you to these advanced functions, explain their applications, and demonstrate how they can efficiently solve common problems. Ideal for advanced Excel users, this course will enable you to use dynamic arrays to streamline your workflow and enhance your data manipulation capabilities.

THIS COURSE IS SUITABLE FOR YOU, IF
You have an advanced knowledge of Excel and want to explore its advanced features.
You want to use dynamic arrays to simplify complex tasks and increase the efficiency of your data management practices.
You have access to Excel 365 or Excel 2021 and want to take full advantage of these newer versions.