Blog & Excel Tips

You have switched on your data filter and tried to use it but you find that the Excel filter is not working after a certain row.

You can spell check Excel documents but there are a couple of tips and tricks you need to use to make it act more like a Word spell check.

How to change the 'invert if negative' colour in Excel to a colour of your choosing and not the white fill with black border default.

A common difficulty with spreadsheet users is how to find a space from the right in an Excel cell. These spaces often result in VLOOKUP's and other functions not working correctly.

Surprisingly, there is no start of month formula in Excel. There is an end of month formula (EOMONTH) but no formula that gives you day 1 of a month based on any date given.

Stop excel users from inserting or deleting rows with 3 methods covering normal protection, only protecting rows and columns, or VBA and protect free stops.

IF function not working with numbers so for example the test 0<5 ends with a FALSE instead of the correct answer

Improve your Excel presentations and dashboards with free stock images built automatically into MS Excel