February 09, 2013, 7:40 AM — There's no dictionary, geographic mapping or flow chart tool baked into the core Microsoft Office 2013 software, but you can still get all these functions for free or a small fee. Developers from Microsoft and beyond have created a variety of apps that you can embed within Word, Excel, PowerPoint or Outlook to work faster and more intelligently.
The new apps for Office are available only for the Office 365 subscription, Office 2013, and some of the Office Web Apps--not for earlier versions of Office. There are three types of apps:
1. Task pane apps typically provide reference information, such as a dictionary. They're supported by the 2013 editions of Excel, Word, Project Professional and PowerPoint. These apps open a task pane on the right side of the current program window, where you work them.
2. Content apps are supported by Excel 2013 and the Excel Web App only. They are embedded inside your worksheet and saved with it. Examples are a calendar date picker or additional charting designs.
3. Mail apps are supported by Outlook 2013 and the Outlook Web App, and they require you to be using Exchange Server 2013. Mail apps won't work with POP and IMAP email accounts, so they're effectively limited to business use. Mail apps display next to an item in Outlook, such as an email message or a meeting request. They access data from the Outlook object to provide additional content--for example, a map showing the location of a meeting.
Additional apps are compatible only with SharePoint Server 2013 Enterprise edition.
How to install apps for Office
Click the Insert tab from within your Office application, then click Apps for Office, See All. A dialog will open, showing My Apps and Featured Apps. In Featured Apps, you can click More Apps to open a browser window leading to the Office store, where you can see the apps available for the program you're using. Or, you can go directly to the Office Store. Here are 10 apps to check out now.
1. Mini calendar and date picker
Need to enter dates into your Excel spreadsheet over and over again? This app embeds itself within a worksheet and pops up a calendar that you click on to insert a date or time into the currently selected cell. You can set your own week start date and color scheme, and enable or disable week numbers. You can do a free trial for this $1.99 app. The apps buying process needs work; after we purchased the app, it still described itself as a trial version. However, the developer was quick to assist when we reached out.
2. Avery templates
Not a paperless office? If you ever print address labels or name tags, then get this free app for Word 2013. This task pane app lets you search for printable Avery products and create a document based on each one. This spares you from having to search for a suitable template or creating one from scratch, for example, labels using the Mailing labels feature in Word.