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

ChatGPT for Excel

ChatGPT for Excel

Sources: zerotomastery.io
Imagine that you have an AI assistant ready to solve any task in Excel. This course will show you how to unlock the full potential of ChatGPT even with basic...
3 hours 23 minutes 27 seconds
Introduction to Excel Automation: Excel Macros and VBA

Introduction to Excel Automation: Excel Macros and VBA

Sources: zerotomastery.io
Studying macros and VBA (Visual Basic for Applications) for Excel is an indispensable skill for anyone who regularly works with data, performs repetitive tasks.
2 hours 44 minutes 10 seconds
Introduction to AI Agents

Introduction to AI Agents

Sources: DAIR.AI
This course is dedicated to creating effective and complex AI agents. Students will study the main components for developing AI agents and best practices for...
1 hour 39 minutes 43 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
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