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....
Quickly fill Blank cells with the Value in the Cell Above
There are situations when you ask someone to punch data for you and they come up with one lazy idea to leave the cell blank if the same value is repeating in subsequent cells...
50+ Excel Tricks Accountants Love by Heart! – Episode 1
I often confront a question "what to know in Excel". Answer to this is not easy. To me Excel is like a journey and it never ends unless you stop. Similarly more you use...
Multi level or Multi column sort in Excel – How To
Before in Excel tips we learnt about Custom Lists feature in Excel and how to use it to sort and have custom autofill series. In our example we sorted the sales data using our...
10+ ways to SUM Top N values in Excel data range – Ready to...
We all love to add things up. Its always good if things add up to the way we want. And no doubt from Excel newbie to pro everyone uses SUM formula. We have recently...
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()....
Comparing two columns to highlight Duplicates in the same row – Excel Conditional Formatting
Back to Excel after a long time. But now starting to relax a little as course is concluded for many subjects I teach. I really missed my Excel community and I really want to...
One minute Excel Tutorial – Remove Duplicates
Data entry is a cumbersome job and often key punch operator ends up recording the same data again. Or if the data has been collected at different sources and on consolidation many similar instances...
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....
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...