Quality Score
Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/
Overall Score : 0 / 100
Live Chat with CourseDuck's Co-Founder for Help
Need help deciding on a excel course? Or looking for more detail on Oz du Soleil's Excel: Using Dynamic Array Functions? Feel free to chat below.
Join CourseDuck's Online Learning Discord Community
Course Description
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.
Students also recommend
-
Microsoft Excel - Online Tutorial for Beginners (2010)
-
0.0 (0 Reviews)
-
- Provider: Chandoo.org
- Time: 1h 30m
Free