Excel: Using Dynamic Array Functions (Microsoft 365)

Focused View

Oz du Soleil

1:30:02

159 View

01. Introduction

001. Using dynamic array functions.mp4

00:40

02. What to Know Before Using the New Functions

002. Introducing spills, dynamic arrays, and the new calculation eng.mp4

07:08

003. Warnings to heed.mp4

06:19

004. Dynamic arrays and tables don't always play nice together.mp4

03:08

03. UNIQUE

005. Unique vs. distinct.mp4

02:15

006. Multiple criteria.mp4

01:19

007. UNIQUE by column.mp4

01:51

008. UNIQUE with two criteria.mp4

00:52

04. SORT

009. Basic SORT and two criteria.mp4

04:09

010. Horizontal SORT.mp4

03:33

05. SORTBY

011. Basic SORTBY.mp4

02:00

012. Horizontal SORTBY.mp4

03:02

013. SORTBY vs. SORT.mp4

02:48

06. SEQUENCE

014. Basic SEQUENCE.mp4

02:35

015. Unstack records.mp4

04:11

07. FILTER

016. FILTER logic Plus.mp4

02:02

017. FILTER logic Asterisk.mp4

02:39

018. FILTER logic Equal.mp4

02:01

019. FILTER logic Minus.mp4

02:13

020. FILTER Logic Greater Than.mp4

02:16

021. Crazy logic Three criteria.mp4

05:11

08. RANDARRAY

022. Randomize data.mp4

02:06

023. Generate random data.mp4

02:23

09. SINGLE

024. SINGLE Implicit intersection.mp4

01:42

10. Putting It All Together

025. The spilled range operator.mp4

05:24

026. Dynamic drop-down list.mp4

05:45

11. Challenges and Solutions

027. Challenge 1.mp4

00:45

028. Solution 1.mp4

03:47

029. Challenge 2.mp4

01:36

030. Solution 2.mp4

04:22

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Excel Formulas and Functions

Microsoft Office 365

Oz du Soleil

Instructor's Courses

Microsoft Excel MVP | YouTube Channel: Excel on Fire | Author, Guerrilla Data Analysis Version 2. Co-authored with Mr Excel, Bill Jelen | Excel Trainer & Instructor | Speaker. I've been working with data and Excel for many years, and have developed a passion for clean data and reliable reporting. An even greater passion is that of teaching, sharing knowledge and empowering people to do handle their data more efficiently and with greater skill to turn their data into useful information. Presented at: #Northwestern University #University of Illinois at Chicago #IgniteChicago #ExcelTV Courses taught: Excel Formulas Data Visualization in Excel 2013 Pivot Tables & Dashboards Excel for Nonprofits: Measuring Fundraising Effectiveness Introduction to Programming VBA

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.