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...

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...

Excel ALTernate ‘Powercut’ – One key to rule ALL shortcut keys

Ranking up in Excel world is not easy but definitely there are steps you can take to become an Excel head and one of such steps is to remember shortcuts. Well you have no...

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...

Excel Mouse Mayhem – 35+ Mouse tricks for mouse mongers

I know many of the Excel users prefer keyboard shortcuts and Excel does provide plenty of them. But if we are keen to know and remember keyboard tricks then we should pay some homage...

30+ Excel Copy & Paste Tricks You Must Know – Mouse Keyboard Autofill Paste...

So here we have the 30+ amazing copy/paste tricks that everyone must know. With these tricks and tips I am hopeful that you will be able to extend your productivity way further than you...

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...

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....