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...
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...
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...
FREE Excel Invoice Template V1.0 with Customer and Product list – Unlocked + Download...
Everyone loves getting paid but to get paid one needs to send invoice and to make an invoice that is not only effective from a business perspective but also help you get invoicing done...
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...
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...