Excel: Using Dynamic Array Functions

Focused View

Oz du Soleil

2:46:37

0 View

01 - Introduction

01 - Using dynamic array functions.mp4

00:44

02 - 1. What to Know Before Using These Functions

01 - Warnings to heed.mp4

07:33

02 - Dynamic arrays and tables dont always play nice together.mp4

04:17

03 - 2. UNIQUE

01 - Unique vs. distinct.mp4

03:06

02 - UNIQUE with multiple criteria.mp4

02:45

03 - UNIQUE made practical.mp4

06:21

04 - 3. SORT and SORTBY

01 - SORT function.mp4

06:37

02 - SORT horizontal.mp4

06:22

03 - Horizontal SORTBY.mp4

02:02

04 - SORTBY cities.mp4

02:11

05 - PIVOTBY.mp4

05:13

06 - GROUPBY.mp4

04:19

05 - 4. SEQUENCE

01 - Basic SEQUENCE.mp4

06:04

02 - Using SEQUENCE to unstack records.mp4

03:23

03 - SEQUENCE flip a dataset.mp4

03:17

06 - 5. FILTER

01 - Introducing FILTER.mp4

03:12

02 - FILTER logic OR and AND criteria.mp4

03:48

03 - FILTER logic Equal.mp4

02:43

04 - FILTER logic Minus.mp4

02:07

05 - Extreme FILTER logic Three or more criteria.mp4

03:58

07 - 6. RANDARRAY

01 - Randomize data.mp4

09:32

02 - Generate random data.mp4

02:46

03 - Midterm introduction.mp4

01:04

04 - Midterm challenge.mp4

03:11

05 - Midterm solution.mp4

08:25

08 - 7. Manipulating Strings of Text

01 - Part 2 introduction.mp4

00:53

02 - Split strings of data with TEXTSPLIT.mp4

02:54

03 - TEXTSPLIT into rows.mp4

02:54

04 - Isolate data with TEXTBEFORE.mp4

01:51

05 - Isolate data with TEXTAFTER.mp4

03:40

09 - 8. Dynamics on Rows and Columns

01 - Convert arrays into single rows or columns with TOCOL.mp4

05:37

02 - Use WRAPROWS and WRAPCOLS to convert data into an array.mp4

04:25

03 - Return specific rows or columns with CHOOSECOLS.mp4

05:41

04 - Extract specific rows or columns of data with TAKE.mp4

07:15

05 - Eliminate certain rows or columns of data with DROP.mp4

02:07

06 - Combine datasets with HSTACK and VSTACK.mp4

04:25

07 - WRAP.mp4

03:55

10 - 9. Challenges and Solutions

01 - Introduction to the final challenges.mp4

00:42

02 - Challenge 1.mp4

01:29

03 - Solution 1.mp4

03:13

04 - Final challenge.mp4

02:30

05 - Final solution.mp4

07:11

11 - Conclusion

01 - Next steps.mp4

00:55

Description

Dynamic array functions in Excel allow users to perform calculations on multiple cells at once, saving time and increasing efficiency. 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 Excel's calculation engine and demonstrates how to make the most of dynamic array functions. He walks through all the key functions—including UNIQUE, SORT, SORTBY, SEQUENCE, FILTER, and newer functions like TOCOL and CHOOSECOLS—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

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.