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
0:00
/ #1: Introduction
All Course Lessons (19)
| # | Lesson Title | Duration | Access |
|---|---|---|---|
| 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 subscriptionComments
0 commentsWant to join the conversation?
Sign in to commentSimilar courses
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
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
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
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