Pretty Much Only Used Again Word and Excel

Ever wish there was a tool that would remove extra spaces and line breaks in Excel with a click? How about an app that translates Outlook emails into another language? Microsoft Office add together-ins let you lot do this—and much more—without switching programs.

Become more than out of your spreadsheets with automation

When you want a bit more from Role, these add-ins each make Microsoft Discussion, Excel, PowerPoint, and Outlook more powerful with new features for gratuitous. Best of all, they work in the gratis Office Online apps as well as newer versions of Office for Mac and Windows.

New to Office Online? Check our in-depth guides to Excel Online and PowerPoint Online to get the virtually out of Microsoft'due south free Function spider web apps.

How We Selected the Featured Microsoft Office Add-ins

There are over ii,000 add together-ins for Microsoft Part 365—and more that only piece of work on specific versions of Role for Windows and Mac. To simplify things, nosotros looked through over 100 of the highest-rated apps for each product (Outlook, Word, Excel, and PowerPoint), installed and tested 47 add-ins that stood out for their unlike features, and narrowed the results down using the post-obit criteria:

• Free: There are a lot of promising paid apps bachelor for Function products, but we wanted to focus on the best free add-ins. Some of the add-ins take paid upgrades, but the basic features described for each add together-in are complimentary to use.

• Broad Audience: Many available apps and add-ins are for specific programs like Salesforce, HubSpot, or Trello—they require the apply of a third-party program. We wanted to highlight apps that anyone can utilize, so we excluded those that are specific to 3rd-political party tools.

• Broad Use Cases: There's a lot you can practise with apps and add together-ons without leaving Microsoft'due south interface—find restaurants on Yelp, search Wikipedia, and buy flowers—but nosotros wanted to focus on the types of apps you could realistically use daily.

• All 365 Applications: We merely included apps that work for all Role 365 subscription types (Home, Student, and Business).

Using these criteria, we narrowed the listing down to the following 22 add together-ins for Outlook, Word, Excel, and PowerPoint, all of which are gratuitous unless otherwise noted:

• Outlook Add-ins

• Discussion Add-ins

• Excel Add-ins

• PowerPoint Add-ins

A note on system compatibility: We tested each add-in using Office Online, the complimentary online version of Microsoft Function, and they should at least also work in whatever version of Office 365. If yous're planning to use these add-ins with a Pupil or Business account, go along in listen that yous may need admin permissions to install them.

How to Use Microsoft Role Add-ins

There are a lot of dissimilar means to use Microsoft Office applications—the various Mac and PC versions of Office (including Role 2013, 2016, and the Part 365 subscriptions), with the newer mobile apps for iOS and Android, or with the Function Online free web apps. Not all add-ins work on every different version of Role, though, and how you install and access the add-ins varies across dissimilar apps, versions, and platforms.

With that in mind, here's how to install and utilise Office add together-ins:

Will This Add-in Piece of work on Your Version of Office?

All of the add-ins in this commodity piece of work in Office Online applications. To decide if an add-in y'all desire to install will work with other versions of Office, follow the link we included for each add-in to see its description page on Microsoft Function's Add-in Marketplace. Then expect for the "Products supported" information in the left sidebar to meet if your version of Office is supported.

How to Install Office Online Add-ins

Installing add-ins in Function Online apps works the same in Word, PowerPoint, and Excel. Open a new or existing certificate, click the "Insert" tab, and select the "Part Add-ins" push.

That will open up the Add-ins pane which shows add-ins yous've installed, ones your company or school has added for your team, along with a store to select new add-ins. To install new ones, click the "Shop" link in the header, then search for the add-in you lot want and click the "Add" button.

In Outlook Online, open Outlook.com, click the settings icon in the bill of fare bar, then click "Manage add-ins." There, you tin search for and install add-in as in other Office apps.

Either way, once you've installed an Office Add-in, you'll always have that add-in whenever you open an Office Online app in whatever browser.

How to Install Office Add together-ins for Mac and Windows

Unfortunately, installing an add-in on an Office Online app doesn't automatically add it to your desktop version of the program. You'll need to do that separately. In Word, Excel, and PowerPoint, open an existing or new document, click the "Insert" tab, and select the "My Add-ins" push. In the add-ins window, click the "Store" link, so utilize the search bar to find the add-in yous want to install, and click "Add.".

Information technology works a bit differently in Outlook. To install add-ins on desktop versions of Outlook, click the "Store" icon in the "Dwelling" ribbon, then search for and "Add" the add-in as before.

Note: Outlook add-ins aren't currently available for Outlook 365 on Mac.

How to Use Office Add-ins

Afterwards installing the add-ins yous want, it tin can be a lilliputian tricky to find and use them. Here are a few common places where the buttons for add-ins appear.

Add-ins may display within ane of the tabs of the program'south ribbon menu:

In Outlook, they may display equally a push at the top of a received e-mail:

If all else fails, render to the add-ins window, select the add-in y'all want to launch, and click "Add." This typically launches the add-in in a task pane inside the application:

How to Delete Part Add-ins

You can't delete add-ins you lot've added to Part programs, but you can hide and disable them. To exercise that, open up the add-in window in the appropriate Part application, and click the "Manage My Add together-ins" link. Click "My Account" in the dropdown, so click the "Hide" link next to any add-in you lot desire to disable and hibernate.

---

With that out of the way, here's our favorite Office Add-ins:

Our favorite free Outlook add-in: Boomerang

Boomerang adds a ton of useful features to Outlook. It lets you lot schedule an email to send at a later engagement and time, pause your inbox when y'all need to focus, then you're not distracted by incoming emails, and schedule a follow-up reminder when you ship an electronic mail then you don't forget about it.

Boomerang too makes it easier to become meetings scheduled. It embeds a visual filigree of your availability into meeting-request emails into emails—and the grid stays upwardly to engagement even if your schedule changes afterward you send the request. That mode, when someone receives your meeting invite electronic mail, they can easily pick the fourth dimension that works best for them.

Another feature—Respondable—uses AI to make up one's mind the likelihood an electronic mail volition become a response. Information technology checks your email's subject and body text length, the number of questions included, and the overall reading level. So it scores your likelihood to receive a response and gives suggestions on how to amend that score.

Boomerang Pricing: Free to employ Boomerang features with up to 10 messages per month. From $4.99/month Personal program unlimited messages.

Other useful Outlook add-ins

Mr. Post Email Inspector

Scammers today are increasingly good at avoiding spam filters and edifice emails that wait identical to those yous receive from your bank, credit card, or LinkedIn account. Click a link and enter your login credentials from one of those emails, and your accounts will likely be hacked. Outlook includes a Safe Links feature to protects yous against phishing attacks. So, for an extra level of safety, add Mr. Post to browse specific emails when you want and meet if links are condom to click.

Email Recovery

Accidentally deleted an important email? With the E-mail Recovery add-in, don't panic. It lets you search for and restore emails y'all deleted from Outlook'south deleted items binder. And if you want to permanently delete emails then that they can't be recovered by the tool in the time to come, Electronic mail Recovery'due south purge tool lets you do that, too.

Template Phrases

If you notice yourself answering the same questions over and over over again or sending the same questions/responses frequently, Template Phrases may save you a lot of time. Information technology lets yous save sections of text and then insert them into your emails with one click. It's like a mini text expander app for your inbox.

Translator for Outlook

Translator for Outlook lets you lot translate emails you receive from over 50 languages. While y'all tin't use the tool to translate emails you've written—and probably wouldn't want to—it could be really useful if y'all receive emails in a language that isn't your first and could benefit from a simple translator to quickly clarify words you don't recognize.

Send Anywhere for Outlook

Outlook limits email zipper sizes to between 25-150MB, depending on your business relationship. Ship Anywhere blows that away and lets you send upwards to 10GB of attachments with your emails. It'southward great if y'all need to ship videos, slideshows, or cipher folders with loftier-resolution images but don't desire to share the files on OneDrive commencement.

Custom Signatures

The complimentary version of Outlook simply lets y'all save one version of your electronic mail signature. Only if y'all manage multiple email accounts in one inbox or demand to use different email signatures for the unlike types of people you interact with, Custom Signatures makes information technology piece of cake to use the right signature in every email you ship. Build your signatures, add HTML formatting and links, and save them. Then, simply click a button to add the correct signature to every email.

Our favorite free Word add-in: Woodpecker

The Woodpecker Legal Document Automation add together-in lets you create standard, reusable certificate templates with customizable blank fields. While in that location are a few unlike template add-ins available for Word, Woodpecker stood out because it doesn't crave you to maintain a library of templates in a dissever application, and it works with the complimentary version of Discussion Online.

It's billed every bit a tool for legal documents, but there are many other use cases. If you write encompass letters or common cold emails frequently and just customize part of the text, you could create a template with customizable fields for the pieces of information you want to personalize. You could besides use it to create proposal templates to send to new clients, or for a template letter for your business concern communications.

Using Woodpecker is simple. After creating your template document, add the customizable fields you need, select the type of required response (unmarried line, date, rich text, etc.), then insert the placeholders into the certificate. When you desire to use the template, but open information technology and customize the fields y'all included, then relieve the new re-create and send it off.

Woodpecker Legal Document Automation Pricing: Free with email address to add single-line text, appointment, number, and rich text fields. From $seven.99/month Yearly programme for in-app back up, default values, and a clear-all-fields tool.

Other useful Word add-ins

MyScript Math Sample

Word'due south born tools to create circuitous math equations are not ever intuitive to use and can be time-consuming. MyScript allows you to write the equations past hand using a touchscreen, mouse, or cartoon pad. Later on drawing your equation, MyScript translates information technology into a typed equation in your Word document. Information technology'southward the simplest way to add together equations to documents.

Symbols and Characters

Word'southward symbol tool contains every symbol you could ever need, but it'southward not always piece of cake to detect what you lot're looking for. You can sort by category, but later on that you have to scroll and scroll, hoping not to overlook the symbol y'all need. The Symbols and Characters add-in lets you search for the graphic symbol yous need, helping you lot find unusual symbols in a snap.

Abbreviation Listing

Abbreviation List scans your certificate and looks for acronyms you've neglected to define—or those you defined more than once—and creates a list for you lot to review. Use it to brand certain you've defined all acronyms to build a document that makes sense to anybody who reads it.

Handy Calculator

If y'all're working on a document that requires a lot of calculations, Handy Calculator is a nifty tool considering it opens a calculator correct in Give-and-take's task pane. You don't have to switch dorsum and forth between Give-and-take and a calculator app or rely on a desk or mobile computer—focus on your content and calculations all on the aforementioned screen.

Our favorite free Excel add together-in: XLTools.internet Data Cleaning

Data in Excel gets messy easily. Whether you've downloaded a CSV file with extra spaces and line breaks, or are collaborating with a squad of people who each enter data in a different format, information technology's time-consuming to go through and manually clean everything up.

The XLTools.internet Data Cleaning add-in makes it quick and easy to clean upwards and standardize content in an Excel sheet. It removes unnecessary leading and abaft spaces and line breaks, updates text case to continue formatting consistent, and adds/removes commas in long numbers.

Using the add-in is simple. Specify the information you lot desire to clean upwards, select what action to perform, and click "Utilise." Annotation that the add-in can only make one change at a time, then if y'all want to remove leading spaces and add commas to long numbers, you'll have to run it twice.

XLTools.net Data Cleaning Pricing: Free

Other useful Excel add-ins

Duplicate Remover

Duplicate Remover does exactly what the championship says: It automatically detects indistinguishable data establish in your spreadsheet. Select the range of data to review, choose whether y'all desire to notice duplicates or repeats, and specify what the app should practice with the data (delete, highlight, or motility it). It'southward an easy way to make sure values aren't skewed by redundant data.

Split Text to Columns

In Excel for Mac or Windows, at that place's a feature that lets you lot separate text from a single jail cell into multiple columns, just this feature isn't available in Excel Online. The Split Text to Columns add-in adds this feature to Excel Online. Choose what delimiter you want to carve up at—space, line interruption, or comma—then click the "Divide" push to split up data into its own columns.

ToDo Listing Pro

ToDo List Pro lets you lot build a to-do list in Excel's side panel. It's a great tool to keep track of things yous recall of while working in the spreadsheet but don't want to complete immediately. The just downside of this add-in is that there's no style to save lists and reuse them on time to come spreadsheets. Each to-do listing only applies to the spreadsheet it was created in—perfect to listing things you need to end in this one spreadsheet.

People Graph

People Graph makes it like shooting fish in a barrel to create infographic-like data visualizations in Excel. Select the data you desire to display (it supports up to 2 columns of data), then customize your graphic using several different styles and a dozen different shapes, including hearts, stars, clocks, diamonds, computers, clothes, and numberless of money.

XLTools.net Calendar

The XLTools.net Agenda app adds a date-picking calendar to Excel's interface. Use it to tap a date on a calendar to add it to a prison cell. It helps y'all avoid having to type dates over and over over again and ensures consequent formatting.

Our favorite gratuitous PowerPoint add together-in: Pickit

No one wants to come across a slideshow then text-heavy that information technology might be mistaken for a manifesto. And while the paid PowerPoint application includes a tool that lets you add images, icons, and other designs to your presentation, PowerPoint Online only provides a Bing image search tool. Bing images are restricted to whatever size they were uploaded at, and even though they're tagged as Creative Eatables, there'southward no guarantee that copyright restrictions won't apply.

Pickit solves this with a huge library of royalty-free stock images, illustrations, and icons you tin can search through and add together to your presentation without leaving PowerPoint's interface.

Search for images by proper name and metadata, or browse by collections or category. Pickit guarantees that y'all tin legally employ all of its images, and its illustrations look squeamish fifty-fifty when resized—though for HD-quality images you'll demand to upgrade to a premium programme.

Pickit Pricing: Costless with ads. From $1.99/month Pro program for ad-costless interface, choice to save images to collections, and Hard disk drive-quality images

Other useful PowerPoint add-ins

Web Viewer

The Web Viewer add-in lets you embed full, functional websites into your PowerPoint presentations, and so you tin share online content without having to go out the slideshow. It'southward a swell way to demo a live version of a new site design for your team or to share an paradigm directly from its link. However, information technology only works with simple websites—blogs and direct file links tend to work every bit long every bit they're secure sites (https://), while more detailed sites like Zapier's landing page or even Google.com don't load.

Spider web Video Actor

PowerPoint has an option to embed a YouTube video into a slideshow, merely videos from other sources aren't supported. The Web Video Player app allows you to include videos from Vimeo equally well, and if you upgrade, you can set exactly what office of the video you want to prove.

• Spider web Video Player Pricing: Free to embed YouTube and Vimeo videos. Old fee of $5 to upgrade to a premium version that supports autoplay and setting specific start and end times.

Pixton Comic Characters

Demand to illustrate a point with people? Pixton Comic Characters allows you lot to cull betwixt 25 different characters to include in your PowerPoint presentations. After selecting a character, customize information technology with many different outfits and poses. It's a neat mode to add together some personality to training presentations that people complete on their own without an teacher or grade.

---

Automate Function 365 with Zapier

Function Add together-ins are a bully mode to add extra features to your favorite Office apps. But sometimes, what you really need is to connect your apps together to allow Office work with your bookkeeping tools, project management apps, CRM, and more.

App automation tool Zapier can help. Here are some of the most pop means to automate Role apps with Zapier:

Role 365 Electronic mail and Calendar Automations

Role 365's electronic mail and calendar tools are a great way to manage your work, and with Zapier's Office 365 integrations, your apps can exercise work for you. It tin can turn your emails into tasks and chat messages, add contacts to email lists and projects, and more than.

Note: Role 365 integrations currently simply piece of work with Office 365 for Business and Enterprise accounts, and don't work with free personal Outlook.com accounts.

Excel Online Automations

Don't copy and paste data into Excel. Instead, utilize Zapier's Excel integrations to exercise that for yous. Zapier can copy new emails, survey results, conversation messages, and more into Excel to build spreadsheets with data almost annihilation you need to track. Yous tin can as well put your Excel data to work and have Zapier create new tasks, projects, template documents, invoices, and more from new spreadsheet rows.

Note: Excel integrations currently merely work with Office 365 for Business and Enterprise accounts.

OneDrive Automations

Or, if your favorite Office Online app doesn't yet have a Zapier integration, you can Zapier'southward OneDrive integration to automatically relieve files that you can apply in OneDrive. Say someone emails you attachments that you want to open in Office. Zapier can copy those to OneDrive so you can open them in Give-and-take or Excel the next time you lot're online.

---

Get More Washed Inside Office

With these great Office add-ins and automations, you lot'll accept fifty-fifty less reason to switch between apps during your work day. The adjacent time y'all need to add survey results to a spreadsheet, calculate some quick sums, detect photos for your presentation, and more, you lot can do it all from your favorite Function apps.

If you love these ideas and want more than, check out all of the over 2,000 Function 365 add-ins on Microsoft Add-in Marketplace, or check out Zapier's Automation Inspiration guide for even more ideas on how to combine Office and your other favorite apps more than productively.

Get productivity tips delivered straight to your inbox

We'll email you lot 1-three times per calendar week—and never share your information.

zehrregrarm.blogspot.com

Source: https://zapier.com/blog/best-word-excel-powerpoint-addins/