Tool guide

Find the right Excel tool

You know the result you need but not which ribbon group contains the action.

What it solves

Use this when…

You know the result you need but not which ribbon group contains the action.

Expected result: A relevant action and its purpose, without needing to memorise ribbon labels.
How to use

Follow these steps

Try the action on a copy of your workbook first.

1
Name the task

Try plain language such as “convert text to numbers” or “find weekend entries”.

2
Read the result

Confirm the description and the Assist Pro or Assist Pro+ tab.

3
Open and inspect

Run the action on a copy or sample and review the output.

Before you finish

Check the output

Confirm the result against the source and keep your own judgement in the loop.

Where to find it

Assist Pro · Find & Favourites

Use Tool Finder if you do not know the ribbon group. Confirm the final location in your installed version.

Common mistake

Unexpected input format

Check headings, selected ranges and text/number formats before running. Work on a copy for consequential changes.

Ready to explore?

Make Excel work better for you.

Start with the current 10-day trial, or speak to us about what your team needs.