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...
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...
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...
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....
Changing numbers Sign in Excel – From Negative to Positive and Vice versa
Another question to answer and very interesting one indeed. Again this question came from our vibrant facebook community. The requirement is to change number signs that is change negative numbers to positive and positive...
Creating and Working with Dynamic Charts in Excel
Title should be "making charts dance to your command in Excel" but lets keep it technical :)
OK let me be very quick at it as I learnt about this almost by chance. I used...
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...
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...
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...