ACST1052 Excel Demo: Introduction to Dynamic Arrays
• Introduction to the concept of an “array” in Excel.
• The SEQUENCE() function, used to generate an array of integers of arbitrary size.
• The #SPILL! error.
• Using dynamic arrays for simple financial mathematics calculations.
• Illustration of one major advantage of dynamic arrays: the reduction in the number of formulas we need to perform our calculations.
(Narrated by Doug Fletcher)
