Just a short little tip this week, due to a hectic diary. When you reference a cell in Excel, you will get its value, but what if you w...

Working with accountants, one of the requirements I often get asked for, is to show negative numbers in brackets. Surprisingly, this is...

Sometimes it can be very handy in a spreadsheet with multiple sheets, to show the sheet name in the sheet itself. Say you have a shee...

I have said this many times before, but one of the things I like most about working with Excel is that there is always something new to l...