Excel: Using Dynamic Array Functions (Microsoft 365)
With Oz du Soleil
Liked by 1,677 users
Duration: 1h 30m
Skill level: Advanced
Released: 3/7/2019
Course details
In September 2018, Microsoft released a new family of functions in Excel called dynamic arrays. With dynamic arrays, a user can write one formula and get many different results. This allows users to build more robust spreadsheets, in less time, with fewer errors. Follow along with Excel MVP Oz du Soleil as he walks you through the new calculation engine and dynamic array functions. He walks through all seven functions—UNIQUE, SORT, SORTBY, SEQUENCE, FILTER, RANDARRAY, and SINGLE—showing practical, real-world uses for each one. Plus, learn how to use the spilled range operator (#) to reference a dynamic spill range. Oz concludes the course with a series of challenges so viewers can practice and master dynamic arrays.
Skills you’ll gain
Earn a sharable certificate
Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.
LinkedIn Learning
Certificate of Completion
-
Showcase on your LinkedIn profile under “Licenses and Certificate” section
-
Download or print out as PDF to share with others
-
Share as image online to demonstrate your skill
Meet the instructor
Learner reviews
-
Juan Carlos (JC) Wicke
Juan Carlos (JC) Wicke
Sr. Business Analyst at Vertafore
-
Anil Bhati
Anil Bhati
Sr. Manager at Tata Communications
-
Christopher T. F.
Christopher T. F.
Dynamic Excel Development; Optimized Excel Solutions for Business: Founder and Excel Developer @ Excel and Access, LLC | Dynamic Excel, Power…
Contents
What’s included
- Practice while you learn 1 exercise file
- Learn on the go Access on tablet and phone