Administrative Assistant's Update - sample

SEPTEMBER 2018 6 Productivity-related add-ins for Word By Arnold Villeneuve I got so excited about my most recent article regarding shar- ing the productivity capability of Microsoft Excel add-ins that I've created two new articles about add-ins for Micro- soft Word and Excel. The Azure Machine Learning sentiment analysis for Twitter feeds was very cool. I hope some of you have already downloaded your organization's Twitter feed and analyzed it. I also hope you sampled some of the many other Excel add-ins that are available, especially the free ones! This article will explore some productivity features of add-ins for Word and the following one will cover add-ins for PowerPoint so stay tuned. What is a Microsoft Office add-in? Add-ins provide optional commands and features for Microsoft Excel. By default, add-ins are not immediately available in Excel, so you must first install and (in some cases) activate these add-ins so you can use them. Some add-ins are built in to Excel, such as Solver and the Analysis ToolPak. Other add-ins are available from the Download Center and must first be downloaded and installed. Finally, there are add-ins that are created by third parties, such as a programmer in your organization or a software solution provider. These can be Component Object Model (COM) add-ins, Visual Basic for Applica - tions (VBA) add-ins, and DLL add-ins. These add-ins must also be installed to use them. But don't worry about the "installation" part as the modern Microsoft Office makes it really easy as you will see. How to add an add-in to Word All Microsoft Office applications support the installa- tion of Office Store add-ins the same way. Click on the Insert Tab, select Store, and then click on the Store tab within the pop-up window. As you can see there are many Word related add-ins to, well, add to your Word application. Let's take a look at some of them. Right off the start you can simply search for a Word add-in that provides a function you have been looking for to help you in your work. For example if you want to have your Word document charts update automatically every time the related Excel Workbook data updates just search for "Excel to Word" and you will find the add-in. (Note: you will need Office 2016 for this add-in). You can also browse by Category. Give it a try and click on Productivity. Make a Word Cloud of your document There are lots of productivity-related add-ins specially geared toward Microsoft Word. The important aspect to note is that some add-ins are standalone and free, some are standalone and cost money, and some are related to your having a subscription account with an online ser - vice like Salesforce or MailChimp, for example, in order to be able to make use of it. Let's find a good one and install it. Scroll down to Lingulab Wordcount and click on the Add button. Lin- gulab Wordcount will analyze your document and create a word cloud from it that you can in- sert into your document to show which word concepts are used more than others. The Lingulab Wordcount add-in will install and open a panel on the righthand side of Word. Now open a document you are familiar with. If the Lingulab add-in disappears then just click on the Insert Tab in the ribbon and select My Apps. Now comes the good stuff. In the Lingulab dialog box click on Whole Document button to create a word cloud. Continued on page 7

• Cover