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 […]
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 big a task but when it comes to productivity then it is definitely a botheration. Or simply what if you want […]
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 encountered by excel users is to print same headings on each page of every print. Or what if your data has […]
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 can occur. This leads to repetition and duplicate entries of records. Well excel handles these nuisance as fast as one click! […]
One minute Excel Tutorial - Multiple Windows / Side by Side view
If you know how to split worksheet in independent work spaces then it makes working efficient as you can be at four different places within same work sheet. To learn how to split check out our one minute excel tutorial on split window However, split feature won’t help if you want to work on two […]
One minute Excel Tutorial - Split Margins / Split Window / Split Screen / Split View
Data is meant to be long and stretched but data segment that we want to attend is sometime too scattered that we cannot help scrolling. But this can be catered if we can somehow split the work space in two independent regions and then observing the two spaces. In excel this is easy with split […]
One Minute Excel Tutorial - Sorting
Having things in order is always a good idea as it increase understandability. Talking about order we can have things in alphabetical order or in reverse alphabetical order or talking in numbers then in ascending or descending order. And this can be done with ease in Excel in one breath.
One minute Excel Tutorial - Freeze Panes
Often we are working on screen that provide limited visibility and thus data flows out of the visible region of the screen and thus we have to scroll up, down, left and right. But this movement sometimes impair our ability to understand the data well as either the row containing headings or column containing name […]
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 always like to involve excel. Most common example is that data entry work is carried out in specialized accounting software but […]
