Microsoft Office is the most widely used office application which has various handy and useful Office programs. Microsoft Excel is one of the best office applications to manage and enter office data. New Excel users find it bit difficult to use formulas, tables and tools present in Excel to perform certain tasks. You can simplify these tasks with the help of add-ins or plug-ins for excel. Add-ins will add extra functionality such that you can perform most functions easily and they can also improve your productivity.

Here are some of the best Microsoft Excels add-ins which you can download and use for free. They can make your calculations, searching cells, removing extra space, tables, etc., much quicker and simple.

Change Units

If you are spending much time in converting units from one form to another then this plug-in is for you. Change Units can convert any combination of units including both English and metric. It provides you with flexible intuitive syntax for easy use. All the converted values will be updated automatically so you do not have to edit values once again. This add-in is available for both Microsoft and Mac versions for download.

Cell Assistant

This add-in for Microsoft Excel will help you to find cells with same formatting or select rows or columns with same format as current cell. You can also use this add-in to search for cells with particular comments, formulas, constants, etc. These features of this plug-in are especially useful for formatting tables in excel.

Duplicate Remover

It is very easy to place duplicates in Excel worksheet if you are working on a large worksheet. This add-in will help you to find duplicates or unique values in worksheet. You can choose to delete duplicate entries or select, copy or color them and also you can move duplicates to new location. This add-in can check for duplicates in 1 or 2 lists or tables with up to 1 million rows.

Merge Tables Wizard

It is a vlookup add-in for Excel which can easily match and merge tables to make your life easy. It can find and merge matching data in two different tables in just 5 steps. You can choose to have two tables in a same worksheet or different workbooks. You can choose one or many columns as matching criteria and choose to add non matched data at the end of the table.

Trim Spaces

Deleting extra spaces or empty cells in a worksheet can be difficult. Using this add-in for excel you can perform this task in seconds and with ease. It will remove all leading and trailing cells in all selected cells. All that you have to do to remove extra spaces is select the cells and click on the run button in the plug-in. There will not be any extra space or cell left in your worksheet.

Excel Utilities

This add-in will add an extra tool bar with most frequently used tools in it. This will allow you to access to the tools with just one click which otherwise will take couple of click to select.