A Comprehensive Guide to PowerPoint Add-ins

Why should you care about PowerPoint?

Since its 1990 debut, PowerPoint has firmly established itself as the go-to presentation tool for business professionals worldwide, boasting over 1 billion installations and a 95% market share.

As a business strategy consultant, I rely heavily on PowerPoint. It's the go-to medium to convey complex client deliverables succinctly and visually. No matter the number of presentations under my belt, producing an engaging slide deck within tight deadlines is always a challenge.

It's not just consultants who sink hours into PowerPoint. A study by Nielson and Empower Corporation revealed that computer-centric employees spend about seven hours weekly on PowerPoint presentations, with over a third of this time on slide formatting. This highlights a vast opportunity for productivity gains, and that's where PowerPoint add-ins come into play.

What is a PowerPoint add-in?

Despite Microsoft's Office suite undergoing an upgrade every three years or so, PowerPoint's evolution appears to have hit a plateau. The infrequent introduction of new tools and features is insufficient to meet the demands of its evolving user base. This has paved the way for third-party developers to cater to these unmet needs by creating add-ins that add functionality to PowerPoint.

PowerPoint, for all its merits, has drawbacks. Ever tried aligning objects across slides? It can be maddening. Add-ins alleviate these issues, enhancing PowerPoint with added functions, all while building on its foundational capabilities.

Types of PowerPoint add-ins

• Proprietary Add-Ins: Many consulting firms have proprietary PowerPoint add-ins (e.g., Deloitte’s PowerPoint Tools, Accenture QPT Tools, Bain Toolbox for PowerPoint, McKinsey's Marvin Tools for PowerPoint, EY SlideFox, PWC Smart Toolbar, Strategy& Toolbar, etc.). These are generally only accessible by employees of these firms, and therefore won’t be covered in this guide.
• Premium Add-Ins: There is a wide variety of premium add-ins, ranging from pricey options to more affordable ones. Many of these add-ins are created by ex-consultants looking to replicate the functionality of their firm's proprietary add-ins once they no longer work there. The issue with a lot of these add-ins is that they can be quite pricey, with some costing over $250USD per year. Fortunately, there are a few gems that offer all the functionality you need for a reasonable one-time fee.
• Free Add-Ins: While the allure of free add-ins is undeniable, they often come with their set of limitations. Sometimes, they lack comprehensive features, have less frequent updates, or may not offer dedicated support. If a developer decides to abandon a free add-in, which happens more often than you'd expect given the limited incentive to keep supporting it, it could potentially ruin the workflow you've gotten used to - a pitfall I've regrettably experienced firsthand. Although I don't personally use free add-ins, I've included a database of the best ones that I've tried at the end of this article for your reference as they are still an excellent option for people who don't spend their days in PowerPoint.

Which PowerPoint add-ins should you use?

I've dedicated considerable effort to identify tools that could enhance my efficiency. After extensive research and testing, I’ve landed on two “essential” add-ins that I personally use in my day-to-day work: PowerTools and Think-Cell.

These add-ins collectively fill the gaps in PowerPoint's native functions, speeding up routine or tedious tasks. Even though I aimed for a minimalistic add-in suite, each one brings something unique to the table, so choosing just one ultimate add-in proved elusive.

Although both of my top add-in recommendations, PowerTools and Think-Cell, fall into the premium category, cost was an important factor in my choices. PowerTools offers a one-time payment for lifetime access, a bargain considering the value it adds to my workflow. As for Think-Cell, my employer currently covers its substantial license fee. Yet, due to the significant amount of time I spend in PowerPoint and the efficiency gains I personally experience with Think-Cell, I would be more than willing to invest in it myself if ever required.

In the next sections, I'll briefly introduce the add-ins in my toolkit, focusing on the features I routinely use to improve my workflow.

PowerTools: The Swiss Army Knife of PowerPoint

Cost: $79USD (Annually) / $249USD (Lifetime access for a one-time payment)

Website: https://pptpowertools.com/

PowerTools is the cornerstone of my add-in lineup. If I could choose only one, it'd be this. With its expansive, thoughtful toolkit, it not only enhances PowerPoint's capabilities but does so without the hefty recurring subscription fees that plague many other popular add-ins.

Why PowerTools Shines

• Extensive Toolkit: Of all the add-ins I've tried, PowerTools has the most comprehensive set of functionality and tools for my particular needs.
• One-time Purchase: In the sea of pricey subscription-based tools, PowerTools' one-time fee offers unmatched value. It trumps similar add-ins, like PPTProductivity or MLC, which charge a hefty annual fee. Pay once, and PowerTools is yours to keep.
• Designed for Professionals: Many add-ins seem tailored for educators or students, brimming with flamboyant animations and transitions. PowerTools, however, resonates with the needs of management consultants and corporate professionals. It cuts the fluff, zeroing in on essential, impactful tools.
• Cross-Platform Compatibility: PowerTools operates seamlessly on both Windows and Mac, making it an excellent choice for those who, like me, switch between platforms.
• Reliable and Bug-free: While some add-ins can bog down PowerPoint, PowerTools runs smoothly, free from noticeable glitches or performance lags.
• Proactive Updates and Support: PowerTools' team regularly rolls out updates and is exceptionally responsive to user feedback. Once, a feature I suggested was included within a month – a testament to their commitment.

Key Features

1. Fix/Insert Bullets: One of the challenges with PowerPoint is maintaining consistent bullet formatting, especially when copying from various sources. PowerTools' ability to format up to four levels of bullets ensures consistency in presentations. Whether you're starting fresh or reformatting an existing text box, it adjusts based on a predetermined bullet format.
2. Copy and Paste Position/Dimensions: Design consistency across slides is crucial. PowerTools makes it easy by allowing you to copy the position and dimensions of a specific element and apply it elsewhere, ensuring uniformity and eliminating tedious manual adjustments.
3. Alignment and Arrangement Tools: Whether you're trying to arrange items in a grid, straighten lines, or remove gaps between shapes, PowerTools offers a suite of functionalities to make this process efficient. The Position/Size Wizard stands out, making it possible to copy the position and size of an object across different slides—perfect for titles, stamps, and other repetitive elements.
4. Table Management: PowerTools shines especially when it comes to handling tables. Beyond basic functionalities, it offers advanced tools such as the ability to quickly format tables to a preset style, convert tables to shapes (and vice versa), split tables, and even sum rows or columns. The 'Row and Column Gaps' tool is particularly handy for financial presentations, making data presentation more digestible.
5. Export Options: Whether you're emailing a selection of slides as a PDF, saving a portion of your presentation, or exporting slide notes to Word, PowerTools covers all these needs. This ensures that your content reaches its intended audience in the desired format without fuss.
6. Inserting Tools: PowerTools offers a myriad of insertion options, from custom footers, copyright symbols, Harvey Balls, to even QR codes. One feature I find remarkable is the 'Insert Table of Contents', saving time for those extensive presentations that need a summary slide. The ability to replace pictures without distorting them is also a valuable tool, ensuring the design integrity of slides.
7. Review and Cleanup: Keeping presentations polished and free from distractions is essential. With PowerTools, you can quickly reset slide layouts, remove shadows, animations, hyperlinks, comments, and more. If you're sharing your presentation and want to make it "READ ONLY", the 'Convert slides to pictures' feature is especially handy. And if you're handing off a draft presentation but want to protect sensitive information, the 'Anonymize' function replaces all text with "Lorem Ipsum", making it safer to share.

PowerTools boasts a comprehensive suite of features designed to streamline and enhance the presentation-making process for business professionals. Whether you're in management consulting, investment banking, or various other sectors that rely on compelling presentations, this toolkit can be a valuable resource. Many other premium add-ins charge overpriced yearly subscription fees. In contrast, PowerTools stands out with its reasonable one-time fee, often presenting a more favorable value proposition for those seeking a robust toolset. The list above provides an overview of its capabilities, but more details can be found in its official documentation.

Think-Cell: Charting Made Simple

Cost: $320USD/Year

Website: https://www.think-cell.com/en/

Think-Cell is a highly regarded PowerPoint add-on specializing in advanced charting and slide layouts. With a user base of over 950,000 people at over 23,000 companies, including 8 of the top 10 consulting firms, it's the go-to charting add-on globally.

While its price tag may seem steep, I'd recommend this add-on to those who use PowerPoint almost daily. PowerTools, while excellent, falls short in enhancing PowerPoint's chart experience, and that's where Think-Cell comes in.

For frequent PowerPoint users like myself, there are three main justifications for Think-Cell's cost:

1. It streamlines the PowerPoint user interface, workflows, and integrations, allowing me to produce charts and slides faster.
2. It enables me to construct charts not natively available in PowerPoint, such as waterfall, Mekko, and Gantt charts.
3. It boosts my chart effectiveness with decorations and features absent in PowerPoint, like CAGR arrows, value difference arrows, and value lines.

Key Think-Cell Features

Think-Cell integrates effortlessly with PowerPoint, adding a new section under the "Insert" tab of your ribbon. The toolbar is easy to use and performs on par with other native PowerPoint components, without any lag.

• Charting: From column, bar, line, area, scatterplots, bubble charts to waterfall, Mekko, Gantt charts, and more.
• Layouts: Auto-adjusting text boxes, process flows, tables, agendas, and table of contents.
• Excel integrations: Automatically populate and update chart data from an external Excel file.
• Extended PowerPoint functionality: Not found natively in PowerPoint, like saving and sending individual slides.

A Note on Think-Cell's Value Proposition: While Think-Cell does come with a significant price tag, it's crucial to evaluate its cost in the context of your professional needs. If you're in roles like management consulting or investment banking where presentations are the lifeblood of client communication, the efficiency gains from Think-Cell can be invaluable. Its features are designed to save hours of manual effort, translating into significant time and cost savings in the long run. Thus, for those who find themselves constantly toggling between Excel and PowerPoint, regularly presenting data-driven analysis, and needing advanced charting capabilities, the investment in Think-Cell can very well justify its costs. But for more casual users, the investment might be harder to rationalize. Always assess the frequency and depth of your PowerPoint usage before diving in.

PowerPoint Add-In Database

I compiled a list of add-ins that I tested as part of my research and experimentation with various PowerPoint add-ins, along with comments as to why it they didn’t make it into my productivity stack. Feel free to consult the list if there are particular features you are looking for, or if you would like to find free alternatives to the paid add-ins that I recommended earlier.

Database of Free Add-Ins

Database of Premium Add-Ins