LEARNING PATH
- Introduction and Workbooks Download
- Getting Fast Help and Other Freebies with Excel Ninjas Group
- What's An Array - Overview and Sheet Demonstration
- What's An Array - Technical Demonstration With Code
- More On One-Dimensional Declaration
- Declaring Non-Traditional Boundaries and Thresholds
- Data Types In Arrays
- Cells Object Lesson and Comparison
- Multidimensional Arrays
Video: 26 minutes, 9 lectures
- Populating an Array with Array() Function
- Populating an Array with Split() Function
- Section 02 Exercise
- Exercise - Solution
- Populating an Array with a Range Via (FOR NEXT) Loop
- Populating an Array with a Range Via (FOR EACH) Loop
- Populating an Array with a Range Directly
- Getting the Start and End Boundaries
- Looping Through a 1 Dimensional Array
- For Each Loop Through an Array
- Looping Through a 2 Dimensional Array
- Subscript Out Of Range - Reasons for Run-time error 9
- Static Vs Dynamic
- Change The Size (on the Fly)
- Resize Array Without Losing Everything
- Returning Array to a Worksheet
- BONUS - Real World Speed Comparison - Case Study
- Storing Array Data
- Storing Array in Names
- Accessing Array from Invisible Name in Names Manage
Video: 1 hour & 27 minutes, 20 lectures
- Using Worksheet Functions on Arrays
- Passing an Array Into a Function or Sub
- Passing an Array Into a Function or Sub (Advanced Example)
- Returning an Array From a Function
- Is Array Function
- Filter() Function
- Join() Function
- Join() Function - Practical Example
- The Erase Method
- Transposing An Array
- Determining Worksheet Range from Array Size
- Dynamic Sorting 01 - 2d Array On Sheet Dynamically
- Dynamic Sorting 02 - Dynamic Sort Record, Syntax and Explanation
- BONUS - ReDim Preserving a Multi Dimensional Array - Part 1
- BONUS - ReDim Preserving a MD Array - 02 Transpose Method
- BONUS - ReDim Preserving a MD Array - 03 Custom Function
Video: 1 hour & 43 minutes, 16 lectures
- Bubble Sorting
- Quick Sorting
- BONUS LECTURE
Video: 10 minutes, 3 lectures
