Comments on: Excel dynamic arrays, functions and formulas

by Svetlana Cheusheva, updated on April 12, 2023

Due to the revolutionary update in the Excel 365 calculation engine, array formulas become very straightforward and understandable for everyone, not just for super users. The tutorial explains what dynamic arrays are, and how they can make your worksheets more efficient. Continue reading →

Products
Windows
Ultimate Suite for Excel Shared Email Templates for Outlook Mail Merge for Outlook Auto BCC for Outlook
Mac Os
Text Toolkit for Excel Shared Email Templates for Outlook Mail Merge for Outlook
Google Workspace
Add-ons for Google Sheets Add-ons for Google Docs
Ultimate Suite
70+ professional tools for Microsoft Excel

This comprehensive set of time-saving tools covers over 300 use cases to help you accomplish any task impeccably without errors or delays.

Merge multiple worksheets

Compare sheets for differences

Remove duplicates

Merge cells in Excel

Calculate dates and times

Combine sheets by column headers

Trim extra spaces

Count characters and words

Convert text to number

See all tools

Works for: Windows
Read more about Ultimate Suite
Shared Email Templates
Reply to routine emails faster than ever

Do not waste your time on composing repetitive emails from scratch in a tedious keystroke-by-keystroke way. Type your response just once, save it as a template and reuse whenever you want.

Quick replies for routine emails

Fully customizable templates

Gorgeous html-based designs

Dynamic templates with fillable fields

Comfortable template sharing

Custom-tailored bulk mailings

Company and team-wide signatures

Easy user and team management

Works for: Windows•macOS•Outlook Online
Read more about Shared Email Templates
Text Toolkit for Excel
35+ handy options to make your text cells perfect

Instead of building formulas or performing intricate multi-step operations, start the add-in and have any text manipulation accomplished with a mouse click.

Trim extra spaces

Convert text to numbers

Count characters and words

Change letter case

Extract text or numbers

Split cells by symbol, string, or mask

Replace unwanted characters

Eliminate leading zeros

Find, extract, replace, and remove strings by means of regexes

Merge columns, rows, or cells into one

Combine rows by duplicates

Works for: macOS•Excel Online
Read more about Text Toolkit
40+ tools to boost your Google Sheets
This smart package will ease many routine operations and solve complex tedious tasks in your spreadsheets.
Read more about Power Tools Try it for free

Add-ons for Google Sheets

Merge Sheets Function by Color Remove Duplicates Compare Sheets Substring Batch Toolkit Easy Mail Merge Advanced Find and Replace See all products

Add-ons for Google Docs

Doc Tools Styles for Google Docs Easy Mail Merge Search & Navigate
Mail Merge
Ideal for newsletters, proposals, and greetings addressed to your personal contacts

Mail Merge is a time-saving approach to organizing your personal email events. It offers:

Customizable and adaptive mail merge templates

Personalized merge fields depending on the recipient or context

Dynamic attachments and images

Mailing lists based on Excel tables

"Send immediately" and "send later" scheduling

Works for: Windows•macOS•Outlook Online
Read more about Mail Merge
Auto BCC for Microsoft Outlook
Automatically BCC your emails using simple rules

Automatically send CC or BCC copies of Outlook emails. Create a BCC rule for all outgoing messages or when specific conditions are met.

Copy your outgoing e-mails automatically

Auto BCC yourself

Key phrases for each condition

Rules for different profiles / accounts

Works for: Windows
Read more about Auto BCC
Downloads
- Current versions
- Archived versions
Services
Documentation
Support
Blog
About us
Purchase

Comments page 2. Total comments: 42

Matthew says:
2020-07-23 at 2:31 pm

This was a great article, thank you very much.