Skip to main content

Supercharge Excel with Dynamic Array Functions & Formulas

3h 8m 53s
English
Paid

Course description

Dynamic arrays in Excel are a real breakthrough! With them, you can simplify performing complex data tasks, make Excel faster, smarter, and more efficient. Dynamic arrays create ranges of values (arrays) rather than returning individual values like traditional Excel formulas do. Whether you are working with unstructured data, analyzing trends, or automating reports, mastering this feature will significantly enhance your level of Excel proficiency.

Watch Online

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 19 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: Introduction

All Course Lessons (19)

#Lesson TitleDurationAccess
1
Introduction Demo
04:24
2
SEQUENCE
13:30
3
SORT
11:03
4
UNIQUE
07:33
5
CHOOSECOLS
08:56
6
FILTER I
13:52
7
Combining FILTER, CHOOSECOLS and SORT
13:00
8
FILTER II
13:25
9
FILTER III
11:03
10
Refactoring with Tables
12:45
11
Refactoring with LET
12:58
12
Project 1 - Introduction
03:49
13
Project 1 - Solution
08:56
14
Combining FILTER, UNIQUE and SORT
08:03
15
Referencing Dynamic Arrays I
10:03
16
Referencing Dynamic Arrays II
11:41
17
Creating Dynamic Drop - Down Lists
08:29
18
Project 2 - Introduction
03:48
19
Project 2 - Solution
11:35

Unlock unlimited learning

Get instant access to all 18 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

Apache Airflow Workflow Orchestration

Apache Airflow Workflow Orchestration

Sources: Andreas Kretz
Apache Airflow is a platform-independent tool for workflow orchestration that provides extensive capabilities for creating and...
1 hour 18 minutes 41 seconds
Kamal Handbook

Kamal Handbook

Sources: Josef Strzibny
At the beginning of the book, it examines what Kamal is, how it operates on a basic level, and the first deployment is conducted. Then, it goes into detail...
Fundamentals of Apache Kafka

Fundamentals of Apache Kafka

Sources: zerotomastery.io
Learn the basics of Apache Kafka from scratch and master building reliable, scalable real-time data processing systems. In this course, you will get acquainted.
2 hours 33 minutes 26 seconds
MobX In Depth With React(Hooks+TypeScript)

MobX In Depth With React(Hooks+TypeScript)

Sources: udemy
This is the most extensive course about MobX you will find online, After a few years of using MobX, I'm really passionate about it and really love it, I decided
2 hours 25 minutes 54 seconds
Cursor AI - Ultimate Course

Cursor AI - Ultimate Course

Sources: Kevin Kern
The course "Cursor AI: A Complete Guide for Developers" is designed for developers aiming to accelerate the process of creating websites, applications...
6 hours 52 minutes 57 seconds