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: 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
Istio Hands-On for Kubernetes
Sources: udemy
Istio is one of the most talked-about frameworks in recent years! If you've worked with Kubernetes before, then you'll want to learn Istio! With this hands-on, practical course,...
12 hours 15 minutes 1 second
The Excel Bootcamp: Zero to Mastery
Sources: zerotomastery.io
The only bootcamp you need to become an Excel wizard. Learn Excel Formulas and Functions, Data Visualization, Pivot Tables, VBA Macros, and much more. Start or
14 hours 19 minutes 32 seconds
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
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...