Custom Data Labels with Colors and Symbols in Excel Charts – [How To]
Is it possible to have colored data labels like red for negatives and blue or green for positive values inside excel chart? This question was asked by some when I posted Variance Analysis in Excel – Making better...
10+ Excel features in Home tab that every beginner MUST learn
1 Don't just Paste, Paste Special!
Position in tab: Clipboard group>Paste button drop down | Shortcut: Alt+Ctrl+V
This one is definitely a speciality in Excel's arsenal of features. Normal paste option only put what you copy...
My Top 10 personal favourite Excel keyboard shortcuts
Everybody has preferences and likeness towards Excel keyboard shortcuts and I am no exception. So here is my personal top 10 list of Excel keyboard shortcuts that help me immensely when going through my...
Dealing with Telephone numbers in Excel – Dialing in the correct format
Many have the impression that Excel is a tool to do maths. But the ones who are using it on daily basis know that Excel is way beyond just calculation and helps you maintain...
Formatting Numbers in Excel – Conditional Formatting Vs Custom Number Formatting
Accountants are always dealing with numbers. And its not always about highlighting positives. In some cases we have to make negative numbers standout and having a negative sign is just not enough. Similarly to...
Changing numbers Sign in Excel – From Negative to Positive and Vice versa
Another question to answer and very interesting one indeed. Again this question came from our vibrant facebook community. The requirement is to change number signs that is change negative numbers to positive and positive...