Using Excel Custom Number Formatting as Data Validation Tool

Excel custom number formatting feature is immensely powerful. From hiding things to formatting telephone numbers correctly, to changing colours to use them to insert symbols in data or chart, it is definitely of great...

Calculate the difference between two times in Excel

Its tough to manage times and sometimes it is difficult to manage the time related calculations even in Excel. Suppose you have a situation where you are given Start and End time and you have to find the...

Formatting Dates in Excel the better way using Custom Number Formatting – How To

Time is of prime importance and having dates in your data is most of the time essential bit of whole. However, making the dates look the way we want is often cumbersome in spreadsheets...

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...

10+ ways to make Excel Variance Reports and Charts – How To

Whether it is daily life thing or any day at work, we are always comparing to see whats good and what is not so good. This differential analysis has a much popular name as variance...

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...