Ultimate Suite of 40+ smart tools
This collection of 40+ professional tools will automate most of your daily tasks in Excel and increase your productivity at least by 50%!
More about Ultimate Suite for Excel
Remove duplicates in Excel
Duplicate Remover will quickly remove duplicates from your Excel worksheets or find uniques. Search in two Excel tables for duplicated rows, choose any columns for comparison.
More about Duplicate Remover
Merge Excel worksheets
Merge Tables Wizard quickly finds and merges matching data from the lookup Excel table to the main one.
More about Merge Tables Wizard
Combine duplicate rows
Combine Rows Wizard merges data from duplicate rows and pulls relevant unique information onto the same line in your table.
More about Combine Rows Wizard
Remove spaces, change case
With Cell Cleaner you get a quick way to trim excess spaces, change text case, convert text to numbers, remove non-printable characters and line breaks in your spreadsheets, and more.
More about Cell Cleaner
Consolidate multiple worksheets
With Consolidate Worksheets Wizard you can combine multiple Excel worksheets from different workbooks into one easily and quickly.
More about Consolidate Worksheets Wizard
Sum or Count Cells by Color
Count and Sum by Color calculates cell data according to their background or text color.
More about Count and Sum by Color
Merge Excel cells
Merge Excel cells, columns, rows keeping all data even if the selection contains multiple data values with the Merge Cells addin.
More about Merge Excel Wizard
Auto BCC in Outlook
Automatically send BCC (blind carbon copy) or CC in Outlook, create different rules and add exceptions for different e-mail accounts when sending your messages.
More about Auto BCC
Silently monitor outgoing e-mail
With Silent BCC for Microsoft Outlook you will have a BCC copy of every e-mail that leaves your company without sender knowing.
More about Silent BCC for Outlook
Reply to Outlook email with template
With Template Phrases add-in you can instantly insert commonly-typed text into your Outlook e-mails, share your templates with co-workers, use various macros and more.
More about Template Phrases for Outlook
Find and manage Outlook contacts
Use Smart Contacts add-in to have immediate access to your recent and favorite recipients; find and email the needed Outlook contact in a click.
More about Smart Contacts
Check email before sending
Outgoing Email Checker for Outlook will check your email before sending it for conditions you define in the rules.
More about Outgoing Email Checker for Outlook
Get notified on each important email
Important Mail Alert scans incoming emails for your alert key words and pops up a notification each time you get an urgent message.
More about Important Mail Alert
Merge two worksheets
Merge Tables Wizard matches and merges two worksheets in Excel in 5 steps. Update and add data to your main table really quickly.
More about Merge Tables Wizard
Count & Sum colored cells
Count and Sum by Color calculates cells according to their fill and font colors.
More about Count and Sum by Color
Create Office add-ins in .NET
Add-in Express for Office and .NET is your all-in-one framework for developing commercial class extensions for all applications and all versions of the Microsoft Office suite, including Outlook, Excel, Word, PowerPoint etc.
More about Add-in Express for Office and .NET
Develop Office plug-ins in Delphi
Add-in Express for Office and Delphi VCL is the powerful platform for creating fast, compact and easy-deployable COM add-ins, Excel Automation add-ins, RTD servers and smart tags for Microsoft Office 2013-2000.
More about Add-in Express for Office and Delphi
Disable Outlook security
Using Outlook Security Manager you can bypass settings and avoid security warnings, alerts or prompts in add-ins and applications that interact with Microsoft Outlook.
More about Security Manager for Outlook
Program IE add-ons
Add-in Express for Internet Explorer is your all-in-one framework that offers a simple and quick way to build thread-safe, secure, isolated, deployable and context-sensitive add-ons for IE 6 - 10.
More about Add-in Express for Internet Explorer
Designer for WiX setup projects
Designer for WiX Toolset in an extension for Visual Studio that enables developers to create any WiX-based setup projects in the familiar Visual Studio way.
More about Designer for WiX Toolset
VDProj to WiX Converter
VDProj to WiX Converter is an extension for Visual Studio 2013 - 2005 that lets developers convert their existing Visual Studio setup project to a WiX Setup project in a click.
More about VDProj to WiX Converter
Remove Duplicates
Compare two sheets to delete the same values; dedupe a single table using one of two wizards that come with this add-on.
More about Remove Duplicates for Google Sheets
Merge Sheets
Find matching records in two sheets to update relevant rows of data in your main table. Five simple steps guide you through the process.
More about Merge Sheets add-on for Google Sheets
Table Styles
Apply style templates to data in your spreadsheets. The add-on comes with a set of pre-supplied table styles and the possibility to create your own.
More about Table Styles for Google Sheets
Merge Values
Join data from adjacent cells without touching your table. The add-on can copy values horizontally, vertically, or in the entire range, and place the results next to your original cells.
More about Merge Values for Google Sheets
Find & Replace
Add a sidebar for advanced search and replacement capabilities when working with your spreadsheet data.
More about Find & Replace for Google Sheets
Random Generator
Create unique raffle numbers and passwords, random dates within a certain time period, and get almost any type of data in the selected range using this Google Sheets add-on.
More about Random Generator for Google Sheets
Find Fuzzy Matches
Quickly check your table data for misprints. The add-on will list groups of fuzzy matches for you to review and correct.
More about Find Fuzzy Matches for Google Sheets
Power Tools
Get a set of smart solutions you have been missing: split text to columns, automatically sum numbers in every column, change case, polish up data format, get rid of unwanted characters.
More about Power Tools for Google Sheets
Excel: featured articles
- How to use Excel COUNTIFS and COUNTIF with multiple criteria
- Creating a drop down list: static, dynamic, from another workbook
- Excel formulas for conditional formatting based on another cell value
- COUNTIF in Excel - count if not blank, greater than, duplicate or unique
- Using IF function: formulas for numbers, text, dates, blank cells
- How to use Excel SUMIFS and SUMIF with multiple criteria
- Change background color based on cell value
- INDEX & MATCH functions in Excel - a better alternative to VLOOKUP
- How to count and sum cells by color
Outlook: featured articles
Customers say
I love the program!
I love the program, and I can't imagine using Excel without it! Ultimate Suite saves me many hours of effort with the projects I manage within Excel. The program paid for itself the first day I used it. You created a really great set of tools for use within Microsoft Excel. Thank you!!!
Robert Madsen
One word... WOW!
I recently bought the package of add-ins for Excel. I've used it ONCE and it has paid for itself. It literally saved me HOURS of work. KUDOS!
Dave Brown
Featured customers
Excel array formulas, functions and constants - examples and guidelines
In this tutorial, you will learn what an Excel array formula is, how to enter it correctly in your worksheets, and how to use array constants and array functions in Excel. Continue reading
How to count cells with text and characters in Excel
This tutorial shows how to count cells with text and characters in Excel 2010-2013. You will find several helpful Excel formulas for counting characters in one or several cells, character limits for cells and get a link to see how to get the number of cells that contain specific text. Continue reading
6 most efficient uses of the INDEX function in Excel
In this tutorial, you will find a number of Excel INDEX formula examples that demonstrate the most efficient uses of INDEX in Excel. Continue reading
Try out super speedy Merge Tables Wizard BETA and share your feedback
What a beginning of the year it was! Not sure about you but I feel like the year is already flying by. Last week we officially finished the BETA version of new Merge Tables Wizard (whew!). So I'll take some time to kick my feet up while waiting for your feedback. Continue reading
Using OFFSET function in Excel – formula examples
Excel OFFSET function examples demonstrate the most efficient ways to use OFFSET in Excel to make dynamic ranges, sum the last N rows, create powerful Vlookup formulas, and more. Continue reading
How to use INDIRECT function in Excel
This Excel INDIRECT tutorial explains the function's syntax, basic uses and provides a number of formula examples that demonstrate how to use INDIRECT in Excel. Continue reading
Excel templates - where to download and how to make custom templates in Excel
Learn how to make your own Excel templates and where to find the best collections of free templates for your Excel such as calendars, budgets, invoices, inventory, charts, and more. Continue reading
How to calculate compound interest in Excel – formula for daily, monthly, yearly compounding
The tutorial explains the compound interest formula for Excel and provides examples of how to calculate the future value of the investment at annual, monthly or daily compounding interest rate. You will also find the detailed steps to create your own Excel compound interest calculator. Continue reading
How to calculate percentage in Excel
In this tutorial, you will lean a quick way to calculate percentages in Excel, find the basic percentage formula and a few more formulas for calculating percentage increase, percent of total and more. Continue reading
How to show percentage in Excel
In this short tutorial, you will find many helpful details about Excel percent format and learn how to format existing values as per cents, how to show percentage in empty cell and change numbers to percentages as you type. Continue reading
Using logical functions in Excel: AND, OR, XOR and NOT
Last week we tapped into the insight of Excel logical operators that are used to compare data in different cells. Today, you will see how to extend the use of logical operators and construct more elaborate logical tests to perform more complex calculations and more powerful data analysis. Excel logical functions such as AND, OR, XOR and NOT will help you in doing this. Continue reading
Excel logical operators: equal to, not equal to, greater than, less than
Many tasks you perform in Excel involve comparing data in different cells. For this, Microsoft Excel provides six logical operators, which are also called comparison operators. This tutorial aims to help you understand the insight of Excel logical operators and write the most efficient formulas for your data analysis. Continue reading
Excel IF function: nested IF formulas with multiple conditions, IFERROR, IFNA and more
The tutorial provides a variety of advanced IF formula examples that demonstrate how to use the Excel IF function with other functions, make nested IF formulas with multiple conditions, use IFERROR and IFNA. Continue reading
