Most Excel users would be used to working with the concept of displaying negative numbers in a worksheet with a preceding - sign in front of the number, something a bit like this below, where I have...

In Excel (and other Office Documents) did you know you can mark your workbook as Final?.  If you have finished work on your workbook, you can discourage any further editing by users by using this...

I download a lot of data form various sources, so the quality and formatting of it can vary significantly.  One issue that occurs a lot of the time is a date field being formatted as text.  It...

I do not see these charts being used much - except for stock market ones but high low close charts are really useful where you have three data series like high, low and average data to show.  The...

Until you know this setting in Excel, it is difficult to see how you can have great looking static images on your Excel sheets.  Being able to lock down your images on a dashboarrd for example to...