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
Watch Online Supercharge Excel with Dynamic Array Functions & Formulas
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 commentsSimilar courses
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
Kamal Handbook
Sources: Josef Strzibny
At the beginning of the book, it examines what Kamal is, how it operates on a basic level, and the first deployment is conducted. Then, it goes into detail...
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
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
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
Want to join the conversation?
Sign in to comment