Here is another useful Excel Function that was introduced with Excel 2007 that just, well, ‘makes sense’ If you’re designing spreadsheets with lots of formulas and lots of data, there will come a time where you need to error-trap some values, so as not to show #DIV/0 or #N/A for example. Whilst there are betterRead More
[Update: Be sure to check out the related article, Highlighting the Highest / Lowest Value on a Chart] If you work with charts frequently, you may sometimes want any negative numbers to be coloured differently to the rest of the chart Take this example, showing average temperatures for Prague We may want to highlight JanRead More
I wanted to do a a post on file security – particularly for Excel files, though much of it will apply to other Office files. There are a lot of misconceptions out there, and people thinking they’re securing their work / their company’s data, when they’re really not! I apologise in advance if it getsRead More
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
Here at Tesco, we operate it many different countries, and often need to communicate with colleagues from around the world. For anyone doing something similar to this, it’s always helpful to know the time zones in both areas. There are a few approaches we can take with this. Method 1 Right Click the time onRead More
