One of my all-time favourite Excel functions has been SUMPRODUCT – it’s versatility was endless, but was especially useful for when you wanted to SUM up some data with multiple conditions, such as sales of Pencils in the East region, perhaps. Using SUMPRODUCT, we’d have written something like this… This works well, but as anyone who hasRead More
One of my favourite features that has been added in recent years, are the Excel Tables. Excel Tables, really, are just a way of formatting your data to make it easier to work with and manage – but despite it having been around since Excel 2007, they don’t seem to have had a huge uptake,Read More
