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
Join premium to watch
Go to premium
| # | Title | Duration |
|---|---|---|
| 1 | Introduction | 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 |
Comments
0 commentsSimilar courses
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
Becoming an Xcode Power User
Sources: pluralsight
In this course, you will learn how to master the skills necessary to work proficiently as an iOS developer by effectively leveraging the power of Xcode.
2 hours 34 minutes 51 seconds
IIQ Complete Course
Sources: udemy
Welcome to Identity and Access Management Course! This course enables you to take the first step to secure your future with one of the hot cyber security produc
33 hours 31 minutes 30 seconds
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
Full-Stack SaaS Development Course on Cloudflare Workers
Sources: backpine labs
This is a practical training where you will step by step master full-stack development of SaaS applications based on Cloudflare Workers. The program is built...
11 hours 27 minutes 15 seconds
Want to join the conversation?
Sign in to comment