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...
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....
Hiding Gridlines in Excel – Learn the Right Ways
One of our facebook community member consulted for Excel help and sent me a sample file. In that I noticed in order to hide gridlines, that are visible by default, were "forced" to disappear...
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...
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...
Understanding Custom Views in Excel
Excel is all about flexibility. With all the built in features there is just endless possibilities the way you can use this marvelous application software. But Excel extends the flexibility even further through custom...
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...
ACCA Online Classes December 2013 Announcement and Quick Excel Tip on Duplicating Excel Worksheets
This time around the post is a mix plate. Some of you were worried that how come key strokes are silent on Excel for more than 24 hours. So here you have the confession...