Entdecken Sie, was Sie lernen können.

Mit Videokursen für Beruf, Studium und Freizeit.

# Microsoft Excel 365 – Dynamic Array Formulas (EN)

Von Simon Sez IT

In this course, participants will explore Dynamic Array Functions, understanding spills and arrays, extracting and counting unique entries, distinguishing between 'Unique' and 'Distinct', and extracting multiple unique columns. They will learn to use functions such as SORT, SORTBY, SEQUENCE, FILTER with various logical operators, RANDARRAY, RANDBETWEEN, XLOOKUP for complex lookups, and XMATCH. The course conclude with Exercise 02.

## Inhalte

 What are Dynamic Array Functions? 02:25 Introduction to Spills and Arrays 06:09 Extract and Count Unique Entries 03:41 Unique vs. Distinct 04:10 Extract Multiple Unique Columns 02:21 Extract Unique Values by Column 03:36 The SORT Function 05:49 The SORT Function: Horizontal SORT 06:06 The SORTBY Function 04:21 The SORTBY Function: Horizontal SORTBY 03:59 The SEQUENCE Function 04:51 The FILTER Function 06:05 FILTER with Logic: + Operator (OR) 05:13 FILTER with Logic: * Operator (AND) 03:59 FILTER with Logic: = Operator (Both or Neither Criteria) 03:09 FILTER with Logic: - Operator (One or the Other but Not Both) 03:25 RANDARRAY and RANDBETWEEN 09:22 Use XLOOKUP to Perform Complex Lookups 07:28 The XMATCH Function 04:09 Microsoft Excel 365 Advanced: Exercise 02 01:27

## Details

• Enthaltene Vorträge: 20
• Laufzeit: 1:31 h
• Enthaltene Quizfragen: 2
• Enthaltene Lernmaterialien: 2

## Dozenten des Kurses Microsoft Excel 365 – Dynamic Array Formulas (EN)

### Simon Sez IT

The mission of Simon Sez IT is to make business and technical software simple to learn. The company was founded by Chris “Simon” Calder and has taught hundreds of thousands of students through its online course platform and popular YouTube channel.

### Rezensionen

(1)
5,0 von 5 Sternen
 5 Sterne 5 4 Sterne 0 3 Sterne 0 2 Sterne 0 1  Stern 0