In Excel 2007, Microsoft have given much more prominence to Tables.  They are useful for formatting data, filtering and producing summary statistics, but they have another use – if you refer to a table (rather than a range) in a formula, they automatically expand when you add data! First, create your table (select a cell [...]

Isn’t it irritating when you keep having to go back into wizards, dialog boxes and formulae to manually change data ranges? You can often get round this problem by using column references or tables. There are times when you want a range to expand itself based on the size of the data, and here’s a [...]