This session is based on a series of magazine articles I wrote that covered dynamic arrays in Excel.

Dynamic arrays replace the more complex arrays. Dynamic arrays are much easier to use and are more flexible and automated.

As an example you can easily extract a unique list of entries from a range, or produce a series of sequential numbers. 

A single formula can populate multiple cells - you have to see it to believe it.