A few months ago I wrote a post  introducing the use of ranges in Excel: Excel Tip: A short introduction to named ranges In that post...

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...