Expert Tips
Excel Hashtag # Errors – causes and solutions
Hashtag # errors can creep into your spreadsheets and indicate that the formula calculation has resulted in an error. Here we’ll explore some of the most common # errors and, more importantly, how to overcome them. #N/A This error is most common when using the VLOOKUP or HLOOKUP formula. It occurs when the value…
Read MoreMind the gap!
When you’re designing your spreadsheets, it can be nice to lay things out with blank rows and columns to separate the data. Although this can make it look pretty, there are some things you need to be aware of so you don’t end up with incorrect results! Sorting If you choose the titles row on…
Read MoreWhat’s so great about Excel Tables?
Microsoft first introduced tables in the 2007 version of Excel. They are a brilliant way of organising data in a structured way and can help to make your spreadsheets look very professional. There are one or two drawbacks, but overall, I really like them. What is an Excel Table? A table is a range of…
Read MoreTop Excel time-saving tips
Excel has masses of features, so picking out just 5 isn’t easy. But here are a few which you may not have come across. Give them a try; you’ll wonder how you ever managed without them! 1. Sum without a formula If you want to see a quick total of a range of values without…
Read More