Array formulae are pretty cool - they very useful for producing tables of stats out of lists (Excel data tables), allowing you to do the equivalent of countif or sumif but with multiple conditions (such as matching the row border and the column border in a table you need to produce). You can also use them with more complicated functions such as medians.