Create your best work with Office 365, and get 1 TB of OneDrive cloud storage for your photos and files. The Office experience you know and love, built for your Mac, PC, iOS and Android devices. Update Office from the Mac App Store. If you downloaded Office from the Mac App Store, and have automatic updates turned on, your apps will update automatically. But you can also manually download the updates: Open the Mac App Store from your Dock or Finder.
You can now get Office Add-ins from the Store or use Add-ins you already have from right within recent versions of Word for Mac and Excel for Mac.
There are two kinds of add-ins: Office Add-ins from the Office Store (which use web technologies like HTML, CSS and JavaScript) and add-ins made by using Visual Basic for Applications (VBA).
If you're looking for a built-in add-in such as Solver or Analysis ToolPak, select the Tools menu and then select Add-ins.
Get an Office Store add-in for Word or Excel for Mac
On the Insert menu, select Add-ins.
To get new add-ins, select Store. To use add-ins you already have, select My Add-ins.
The add-ins you'll see will depend on the app you're using and the kind of Office 365 subscription you have.
Office for Mac doesn't currently support organization-based add-ins.
Msdn Subscription
Get a VBA add-in for Word or Excel for Mac
On the Tools menu, select Add-Ins.
In the Add-Ins available box, select the add-in you want, and then click OK.
Requirements
Microsoft Subscription Download
Office Add-ins aren't available in Office for Mac 2011. They're only available in newer versions.