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
Seeing as it’s coming up to Summer and many of us are taking time off, let’s take a moment to see how we avoid the issue of your mailbox getting clocked up because of those 10MB reports you get every day! This works for Outlook 2010. I’m not sure if it applies to 2007 orRead 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
