Excel Add-in- ASAP Utilities

This add-in is called “ ASAP Utilities”.Its absolutely free and used by 2 million users across the world. what you need to do is download the a ~10 MB tool and Install it on your computer.
The install procedure is very simple.
It automatically opens Microsoft Excel and loads the add-in. You will see an additional item in your menu bar called “ASAP Utilities”
Here is the download link
here is what ASAP Utility says ....
“ASAP Utilities is a powerful Excel add-in that fills the gaps in Excel and automates frequently used tasks. Since 1999 it has grown to become probably one of the world's most popular add-ins for MS Excel.”

They are right in saying so…
Why ?
They are good number of tasks that are repeatedly done in excel and takes huge time. With ASAP Utilities you can accomplish them just with a click of a button or may be few clicks.Look at some examples.
  • Eg 1: You have 20 sheets of data. You need to create an index page with links to all the sheets.In normal excel , it is a time consuming process to create a link to each page. Here it is just a click of a button.
  • Eg 2: To delete all hidden or empty rows and columns, in the normal excel you need to unhide the rows select them and delete. Here it is again just a click of a button.
  • Eg 3: Sort the continents of a column based on the colour of the cells, font of the cells is an impossible feat to accomplish in excel . Here it is just a click of a button.
The site has video tutorials
There are many more. All you need to do is explore.
I guarantee you that your excel working time will at least crash down by 50%.
Your productivity Improves !