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

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
Cursor: Coding with AI

Cursor: Coding with AI

Sources: DAIR.AI
The course "Cursor: Программирование с AI" teaches the creation of web applications using the capabilities of artificial intelligence in the Cursor tool.
2 hours 45 minutes 57 seconds
The Complete Strapi Course - with plugins and deployment

The Complete Strapi Course - with plugins and deployment

Sources: udemy
The Complete Strapi Course teaches all you need to know to start and improve your skills with Strapi! Learn about Strapi, the Headless CMS, as well as React and
15 hours 4 minutes 4 seconds
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