30% off your first 3 months

Get the deal
Excel logo
APP GUIDE
The desktop app or the web

How to use DuckyHelper in Excel

Excel is where small mistakes hide: a stray space, a column of dates to fill, an export to tidy. Ask DuckyHelper about the sheet on your screen and it marks the problem and explains it. You can also hand it the filling or cleaning job (in the Mac app).

Works on Mac, Windows and LinuxDoing jobs is in the Mac app
01
ASK
Works now

Find out why a SUMIF returns zero

YOU SAY
“Why does this SUMIF give me zero when the region is right there?”
Press fn (Ctrl+Shift+Space on Windows and Linux) and say it out loud.
What happens
  1. 01Click the cell with the formula so the formula bar and the table are on screen.
  2. 02Ask out loud. DuckyHelper reads the formula and the cells it looks at.
  3. 03It circles the zero and underlines the cell the formula looks up.
  4. 04It says what is different about that cell and how to fix it.

You getYou know the exact cell that breaks the match and how to fix it.

ExcelRegional sales
=SUMIF(A2:A5,C2,B2:B5)RegionSalesLook upTotalWest$4,200West 0East$3,100West$2,800North$1,900
The 0 is because the lookup cell holds West followed by a space, so nothing matches. Delete the space.
Demo · example pageClip · 6 sStill
02
ASK
Works now

Explain where a budget went

YOU SAY
“Explain this month's spend so I can tell the team where it went”
Press fn (Ctrl+Shift+Space on Windows and Linux) and say it out loud.
What happens
  1. 01Have the month's spending on screen, with the categories and amounts.
  2. 02Ask out loud. DuckyHelper opens the blackboard.
  3. 03It draws a bar for each category and adds them up as it talks.
  4. 04It marks the one worth looking at, says its share of the total and what halving it would save in a month and a year.

You getA spoken breakdown with every number worked out where you can follow it.

BlackboardWhere the money went

Halve it and you keep 205 a month, 2,460 a year.

Demo · example pageClip · 13 sStill
03
JOB
On Mac

Fill in due dates from invoice dates

YOU SAY
“Fill in each invoice's due date in column D, 30 days after the invoice date”
Press fn (Ctrl+Shift+Space on Windows and Linux) and say it out loud.
What happens
  1. 01Open the Invoices sheet and say which column to fill and the rule.
  2. 02DuckyHelper works in Excel with its own cursor, row by row, while you keep using yours.
  3. 03It adds 30 days to each invoice date in column B.
  4. 04It finishes with a done card showing what it filled in.

You stay in controlIt does the job without stopping to ask. A Stop control stays on the window the whole time, Take control hands it back to you, and the task is recorded so you can watch it again.

You getEvery due date filled in, so you can check them against the invoice dates.

On Mac
Done
Due dates in column Din ExcelWorked for 9s ›Filled in 5 due dates, 30 days after each invoice date.
What should I do next?
Demo · example data · Mac appClip · 10 sStill
04
JOB
On Mac

Clean up a messy export

YOU SAY
“Split the names into first and last and remove the duplicate rows”
Press fn (Ctrl+Shift+Space on Windows and Linux) and say it out loud.
What happens
  1. 01Open the exported sheet and say what to split and what to remove.
  2. 02DuckyHelper reads the sheet and adds two columns for first and last name.
  3. 03It finds rows that repeat and removes them.
  4. 04It finishes with a done card listing exactly what changed.

You stay in controlIt does the job without stopping to ask. A Stop control stays on the window the whole time, Take control hands it back to you, and the task is recorded so you can watch it again.

You getA tidy sheet with first and last names split and the repeats removed.

Clean up the exportExample · Mac app
Demo · example data · Mac appClip · 7 sStill
TIPS

Getting more out of it in Excel.

  • 01

    Click the cell you mean before you ask, so the formula bar shows what it needs.

  • 02

    For a formula bug, ask what is different about the cells it compares, not just what is wrong.

  • 03

    Before it removes rows, keep a copy of the sheet. Removed rows are gone from the file you have open.

  • 04

    Building a deck from the numbers? See the PowerPoint guide.

FAQ

Questions about Excel.

Do I need to connect my Excel account?

No. There is nothing to connect. It sees what is on your screen while the pill is open, and for jobs (in the Mac app) it uses Excel on your computer or the web with its own cursor, signed in as you. It's built not to type your passwords or card numbers.

Does it use macros or add-ins?

No. It does not run macros, VBA or add-ins. It works in the sheet on your screen like a person does.

Will it give financial advice?

No. It explains the numbers that are on the sheet. Decisions are yours.

Does it see everything in your workbook?

No. When you ask a question it looks only at what is on your screen, and only while the pill is open. A job you start in the Mac app opens only the pages that job needs.

Questions and jobs

Do anything

Ask it a question or hand it a job, in any app.

Doing jobs for you is in the Mac app. Asking works on Mac, Windows and Linux.