Entdecken Sie, was
Sie lernen können.

Mit Videokursen für Beruf, Studium und Freizeit.

Überall verfügbar
Lernen Sie am PC oder mobil auf Tablet oder Smartphone.

Tempo

Eigenes Lerntempo
Wiederholen Sie, sooft Sie wollen.

Schneller Lernerfolg
Lernvideos, Übungen und Quizfragen bringen Sie ans Ziel.

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

Quiz zum Kurs „Microsoft Excel 365 – Dynamic Array Formulas (EN)“

Details

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

Diese Kurse könnten Sie interessieren

Microsoft Excel 365 Advanced (EN)

Simon Sez IT

(1)

~~12,30 € mtl.~~ 4,99 € mtl.

Sie sparen 59 %

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