Dynamic Array Formulas
Dynamic Array Formulas
Purchase this course to access all lessons and start learning.
Already purchased? Log in
Introduction
| Video | Time |
|---|---|
| Save Video 1. What are Dynamic Array formulas? Watched | 3:14 |
| Save Video 2. New dynamic array functions in Excel Watched | 3:38 |
| Save Video 3. Spilling and the spill range Watched | 2:34 |
| Save Video 4. Dynamic arrays are native Watched | 2:52 |
| Save Video 5. Nesting dynamic array formulas Watched | 3:02 |
Array formula basics
| Video | Time |
|---|---|
| Save Video 6. What is an array? Watched | 2:34 |
| Save Video 7. What is an array formula? Watched | 2:53 |
| Save Video 8. 3 basic array formulas Watched | 2:55 |
| Save Video 9. How to see arrays in formulas Watched | 2:55 |
Boolean operations
| Video | Time |
|---|---|
| Save Video 10. Introduction to Booleans Watched | 3:22 |
| Save Video 11. How to convert Booleans to numbers Watched | 3:08 |
| Save Video 12. Boolean algebra in Excel Watched | 3:00 |
| Save Video 13. Array formulas with AND and OR logic Watched | 3:36 |
| Save Video 14. Boolean operations in array formulas Watched | 3:14 |
Sorting with formulas
| Video | Time |
|---|---|
| Save Video 15. Basic SORT function example Watched | 2:33 |
| Save Video 16. Basic SORTBY function example Watched | 2:48 |
| Save Video 17. SORT and SORTBY with multiple columns Watched | 3:02 |
| Save Video 18. Sort by custom list with SORTBY Watched | 2:50 |
| Save Video 19. How to perform a random sort Watched | 2:31 |
Filtering and extracting data
| Video | Time |
|---|---|
| Save Video 20. FILTER function basic example Watched | 2:44 |
| Save Video 21. FILTER function with two criteria Watched | 3:21 |
| Save Video 22. FILTER data between two dates Watched | 3:06 |
| Save Video 23. FILTER with boolean logic Watched | 2:57 |
Unique values
| Video | Time |
|---|---|
| Save Video 24. The UNIQUE function Watched | 3:12 |
| Save Video 25. How to count unique values Watched | 3:22 |
| Save Video 26. Unique values with criteria Watched | 3:08 |
Generating numeric sequences
| Video | Time |
|---|---|
| Save Video 27. The SEQUENCE function Watched | 3:11 |
| Save Video 28. SEQUENCE of dates Watched | 2:45 |
| Save Video 29. SEQUENCE of times Watched | 3:03 |
Generating random values
| Video | Time |
|---|---|
| Save Video 30. How to generate random dates Watched | 2:53 |
| Save Video 31. How to generate random times Watched | 2:45 |
| Save Video 32. How to generate random text values Watched | 2:58 |
XLOOKUP
| Video | Time |
|---|---|
| Save Video 33. Basic XLOOKUP example Watched | 2:48 |
| Save Video 34. Basic XLOOKUP approximate match Watched | 3:22 |
| Save Video 35. XLOOKUP with multiple lookup values Watched | 2:39 |
| Save Video 36. XLOOKUP with boolean logic Watched | 3:05 |
Text functions
| Video | Time |
|---|---|
| Save Video 37. Excel TEXTAFTER function Watched | 4:15 |
| Save Video 38. Excel TEXTBEFORE function Watched | 3:48 |
| Save Video 39. TEXTAFTER and TEXTBEFORE advanced options Watched | 3:41 |
| Save Video 40. TEXTAFTER with TEXTBEFORE Watched | 3:48 |
| Save Video 41. Excel TEXTSPLIT function Watched | 3:17 |
| Save Video 42. TEXTSPLIT with multiple delimiters Watched | 3:58 |
| Save Video 43. TEXTSPLIT with numbers Watched | 3:30 |
Practical examples
| Video | Time |
|---|---|
| Save Video 44. Two-way summary with dynamic arrays Watched | 3:37 |
| Save Video 45. How to show top or bottom n results Watched | 2:56 |
| Save Video 46. Filter with dynamic dropdown list Watched | 2:55 |
| Save Video 47. List duplicate values with FILTER Watched | 2:52 |