Learning centre

Find the next useful Excel task.

Pick a tool by the result you need. Short guides show when to use it, what to select and what to check afterwards.

New in the toolbar / Find a Tool

Know the job. Find the tool.

You do not need to memorise 250+ names. Search by the task you want to finish — then open the tool or its own guide.

A simple path

Start here, even if you are new

Three steps to your first useful result.

01 · SET UP

Install Assist Pro

Check requirements, get the installer and open the two ribbon tabs in Excel.

Install guide ↗
02 · TRY

Use a sample task

Follow the first five wins on a copy of a workbook.

Start learning ↗
03 · REPEAT

Save what helps

Keep a favourite or a reviewed Macro Wizard action for the next file.

See Macro Wizard ↗
Explore a tool

Ten useful starting points

These are recommended starting tools, not a measured popularity ranking. Each card opens that tool directly.

CREATE

Macro Wizard

Describe, test and save your own repeatable Excel action.

Open guide ↗
CLEAN

Convert to Numbers

Make imported numeric text usable in formulas.

Open guide ↗
CLEAN

Smart Splitter

Separate a combined field into columns.

Open guide ↗
REVIEW

Duplicate Finder

Locate repeated records for inspection.

Open guide ↗
CLEAN

Flip Signs

Correct the sign of a selected set of values.

Open guide ↗
GL PREP

Xero GL Cleaner

Prepare a ledger export for the next review.

Open guide ↗
SAMPLING

Random Sampling

Choose and document a sample from a defined population.

Open guide ↗
ACCOUNTING

Debit/Credit to Amount

Bring separate debit and credit fields into an amount column.

Open guide ↗
Browse by task

Choose the work you do

Start with your task; the exact Excel tab is shown on the tool page.

Everyday Excel

Clean and organise

Numbers, text, duplicate rows and repeated workbook routines.

Explore tasks ↗
Accounting

Prepare financial data

Balances, debit and credit fields, GL exports and movement checks.

Explore accounting ↗
More help

Need a specific tool?

Search the full ribbon directory by name, task, audience or Excel tab.

Open searchable tool library Common questions
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.

Build your own tools

Learn Macro Wizard.

Follow the full guide to prompts, controls, editing, saved macros, testing and troubleshooting.

Open the Macro Wizard learning guide