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