Fix Date Sort/ Format issues in Excel, Negative numbers in red brackets, value message with Sumifs, Excel training

MS Excel Tips, Tricks and News

If you are having date format or sort issues in Excel (dates sort by months instead of day of month, you can’t change the date format of a cell), it is because Excel does not recognise the date you gave it as a valid date.

Upcoming Live and Virtual Excel Courses

One of the most common formatting requests is how to get Excel negative numbers in brackets (and red) instead of just a negative sign (-) in front of the number.

Our featured online Excel course. Lifetime access, with skills assessment which allows you to match to the correct course.

When you use SUMIFS in a formula you may discover that your get a SUMIFS value error. Normally a value error means that one of the references is not a value but in this case the reason is different and more importantly it acts differently to the normal SUMIF.

An example of a recent consulting job we have completed.

Feedback from recent MS Excel courses

Missed a newsletter? Look at the Archive