How to show 0 (digit) as text ZERO or Nil or anything in Excel
https://www.youtube.com/watch?v=75cCLEoKzSU
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...
40+ Excel navigational shortcuts to make accounting job super efficient
With the advent of user interface we are able to use mouse and other input devices. But when it comes to speed, efficiency and productivity keyboard is still EXCELlent above anything else i.e. K...
Resume excel session with Save workspaces feature
In accounting world some work is repetitive and accountants have to open certain set of files almost on daily basis. Opening each file by reaching the location and double clicking might not be that...
Entering data on multiple Excel worksheets in one go
If you have several excel sheets to work on and all the sheets share exactly the same data with exactly the same format. Than instead of copying and pasting the same data on different...
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...
Excel Tutorial – Ctrl P is Power in Control (Printing)
Yeah I know even a child with rock bottom skills know how to print. But Excel's print is not just a Ctrl + P. Its this and much more. One of the nuisance often...
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...
Top 10 Excel keyboard shortcuts for Accountants
Excel and accountants are two interconnected entities. Around the world excel is the most active computer application in the hands of accountants. Even if accountants have some other accounting software at their disposal they...