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
Scale React Development with Nx

Scale React Development with Nx

Sources: egghead
On the surface, starting a project sounds easy. First you make some directories, install some dependencies, then you write some code. But there's a bit more to
1 hour 34 minutes 10 seconds
Cursor: Learn to Code with AI

Cursor: Learn to Code with AI

Sources: Mckay Wrigley (takeoff)
The course teaches how to use Cursor to accelerate software code development. The course covers working with various features of Cursor, demonstrates best...
4 hours 50 minutes 14 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
Complete FastAPI REST course + AWS + Emails + Payments

Complete FastAPI REST course + AWS + Emails + Payments

Sources: udemy
Starting with a new framework is easy. Mastering it is hard. Learning by doing is the most successful way to gain your skills on a given topic quick and easy.
9 hours 38 minutes 51 seconds