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
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
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
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
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
Effective PyCharm (2021 edition)
Sources: Talkpython
PyCharm is the premier Python IDE (integrated development environment). You will be hard pressed to find an editor that gives a more holistic way to build Python applications. W...
7 hours 30 minutes 43 seconds
Want to join the conversation?
Sign in to comment