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

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

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

Birth Dates Heat Map in Excel – How To

First off whoever has birthday on July the 7th my best wishes to all of them. You people have a very interesting birth date. 7 and 7. Everyone's birthday is interesting in one or...

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

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

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

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

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