By Andrew Gould

Download files here https://www.wiseowl.co.uk/excel/videos/excel-general/excel-spilled-arrays/

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

Spilled array formulas provide several advantages over traditional formulas in Excel. If you're working with Office 365 or Excel 2021 it's well worth learning how to use this type of formula effectively.

Chapters
00:00 Topic list
00:47 Creating a Basic Excel Formula
02:26 Creating a Spilled Array Formula
03:33 Comparing Normal Formulas and Spilled Arrays
06:16 Absolute and Relative Referencing
08:27 Horizontal Arrays
10:09 Referencing Existing Spilled Arrays
11:34 Spilling Vertically and Horizontally
13:21 Multiplying Tables
15:22 Using Named Ranges
20:14 Using Excel Tables

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!