Excel: Using Dynamic Array Functions (Microsoft 365)
With Oz du Soleil
Liked by 1,675 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.
-
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
-
-
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…
-
Khaled_M_Ali Aklan Albanna
Khaled_M_Ali Aklan Albanna
I.T. Consultant at YBRD | Intelligent systems developer and analyst
Contents
What’s included
- Practice while you learn 1 exercise file
- Learn on the go Access on tablet and phone
Similar courses
Download courses
Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.