How to sort Rows horizontally left to right instead of Columns vertically top to bottom in Excel
Sorting is one of the many good things excel offers. And it does make our job a lot easier once the data is arranged in particular order. However there is one limitation to the usual use of sorting i.e. it sorts in vertical fashion that is columns are sorted top to bottom in the order […]
How to convert numbers into words in Excel - VERY QUICK TIP
I have been working on a small piece and I came across one requirement that in letters to customers in addition to amounts reported in numbers it must also include amounts receivable in words. Well I wasn’t paying attention to that part in the beginning. It don’t even cross my mind that there is no […]
Calculating number of days between two dates - Excel Function Vs Common Sense
Business and every aspect of our life is about time and we have to compute days most often. To handle this Excel does provide a solution for in shape of a dedicated formula DAYS360(). And if you are an accountant you might have sprung half way and suspended there. Although accountants may accept 360 days […]
Replace a formula with the value or final result - Super Easily
Formula and Excel is a bond not meant to break. Although formula do help us get the values we want. But often you find that it will be code that you just get have the result itself what the formula computes. That means you want to hard code the cell with the result and replace […]
Using SUMIF with Dates in Excel
I was in the middle of making an accounting project where I had to use SUMIF. This wonderful function that everyone must know especially accountants. In many instances SUMIF can be used as an alternative to VLOOKUP function and it is much easier to use as well. However, using this formula with dates is a […]
How to change currency format in Excel? How to have Pakistani Rupees (Rs) currency sign in excel?
In almost every office of the world when it comes to money accountants come to excel. Although excel can handle money matters but when it comes to currency by default we have Dollar ($) as currency and not every country have this currency nor have the same currency sign. Accountants who are new often struggle […]
Excel Most Wanted - Selection shortcut keys Mega collection
While working in Excel or any data related job selection is one job in itself. And even in Excel it is not easy when you making your way through thousands of cells. However, life is much easier if you know selection tricks Excel has to offer and even better is they come in shape of shortcut keys […]
One minute Excel Tutorial - Watch Window
Accountants and analysts around the world does one amazing job and that is they give the meaning to mammoth data by processing it using their skills and the same information is then used by managers to make decisions. Everyone wishes to be an analyst or a consultant that people seek for advice. However, as we […]
Excel Custom Shortcuts - Reaping real benefits of Quick Access Toolbar
Many excel beginners especially those who are using version 2007 and later a small bar which is by default placed above ribbon alongside the title bar and many recognize it for its UNDO button. Well it deserves a respect because if it is a toolbar than actually it means efficiency and by overlooking it we are overlooking […]
How to show 0 (digit) as text ZERO or Nil or anything in Excel
Excel is about measuring and calculating but it is not only just numbers it can also help you make the information more understandable and user friendly. In calculations we often get a result 0 instead of any positive or negative digit or number. If you desire highlighting this result and instead of a digit 0 […]