Microsoft Excel 365 Advanced: Part 1 of 9. Dynamic Array Formulas

In this course, you’ll learn about the revolutionary dynamic array functions introduced by Microsoft that enable you to write one formula and obtain multiple results.
You’ll explore the new dynamic array functions, which include UNIQUE, FILTER, SORT, SORTBY, and XLOOKUP. This course is perfect for anyone looking to enhance their data analysis skills.
This course ensures a thorough and engaging learning experience with short, focused lessons. Practice exercises will help you test your knowledge and reinforce your skills.
By the end of the course, you should be fully equipped to use Excel at an advanced level, boosting your confidence and efficiency.