Add More Functions To Office 2007 By Installing Add Ins

Open Excel and click on the Office Button and go to Excel Options and then Add-ins.

In the View and Manage Office Add-ins window, near the bottom. make sure “Excel Add-ins” is selected in the drop down box and click Go.

This will open up the Add-Ins window where you can select an appropriate package for your Excel tasks.  If you highlight each Add-In you’re provided a quick description of what each one is.

In this instance I installed the Euro Currency Tools.  After choosing the one you want click OK and accept the default

You will get a progress message while the add-in is installing.

After the add-in is installed it will be available in the Ribbon.  In this case the Euro Currency Tool was place under the Formulas tab other add-ins may vary.

Other times you can install an add-in from downloading an executable from the Microsoft Office site.  For Instance previously I wrote about the Save to PDF add-in for Word 2007.  Another one I featured was adding a Creative Commons license to documents.

Of course there are also third party add-in programs that usually require purchasing a license after a trial period.  You can add a bit of security by making sure add-ins are digitally signed.  This is done through the Trust Center.  Go to the Office Button Options Trust Center Trust Center Settings and finally Add-Ins.

Here you can add or change settings to your preference.  You can even disable them all together.