Find me on LinkedIn

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 More

Mind 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 More

What’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 More

Top 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