Ablebits Ultimate Suite

What it is

More than seventy tools grouped under headings like Merge, Dedupe, Compare, Transform, and Delete. Each tool opens in a task pane with a step-through wizard rather than a dialog box, which reduces the risk of running a destructive operation on the wrong range. A perpetual licence is available alongside an annual subscription, and the same company maintains a free blog with worked tutorials for Excel tasks that do not require the add-in.