.theseoINSTITUTE FOR VISIBILITY
About this choice

We only save your display preference in a preference cookie, for up to 180 days on this device. No CRM or advertising data. Your tracking consent stays unchanged. If cookies are blocked, your choice may not be saved.

Discover
Close

Excel assistant · IN SHORT

From question to formula.Check a small case yourself.

Describe your columns and the result you need. The Excel skill proposes a formula, explains references and considers whether a pivot table or Power Query would suit recurring work better.

Download the skill (English)Explore the example
Excel assistantSKILL

Your brief

A2:A20 contains project codes and B2:B20 contains hours. In E2 I need the hours for the code in D2. My Excel uses English functions and commas.

Possible draft

Fictional example: hours by project

Proposal: =SUMIF($A$2:$A$20,D2,$B$2:$B$20). The ranges stay fixed when copied down; D2 changes. Filter one project and total its hours separately before relying on the result.

Illustrative example
Illustrative example

01 / THE FOUNDATION

You bring the context.The skill adds structure.

What you provide

  • Sheet names, columns, ranges and an anonymised example.
  • Excel version or Sheets, platform, function language, separator and required output.

What you get back

Dutch and English formula reference versions, an explanation, relevant pitfalls and a check for your own workbook.

02 / SEE HOW IT WORKS

From an idea to a draft.

Illustrative exampleFictional example: hours by projectRead the example

Your brief

A2:A20 contains project codes and B2:B20 contains hours. In E2 I need the hours for the code in D2. My Excel uses English functions and commas.

Possible draft

Proposal: =SUMIF($A$2:$A$20,D2,$B$2:$B$20). The ranges stay fixed when copied down; D2 changes. Filter one project and total its hours separately before relying on the result.

This example shows the approach. It is not a client result or a guarantee of a particular outcome.

03 / GET STARTED

A repeatable approach.Your own context.

  1. Describe the actual sheet

    Confirm the range, application, settings and intended calculation.

  2. Build and explain

    Explain arguments and fixed references, adapting the paste-ready formula to the confirmed separator.

  3. Check a small case

    Compare with a hand-calculated selection and investigate differences before suppressing errors.

04 / MAKE IT YOURS

Ready foryour work.

Take the instructions, add your own context and review the draft. You stay in control.

Full information

Excel assistant

Download. Apply. Refine.

Download the skill (English)

File language: English

From download to use

  1. Save the ZIP file: ai-excel-assistant-skill-for-claude.zip.
  2. Using Claude? Follow the installation guide for your environment. Downloading alone does not activate the skill.
  3. Then provide your own brief and the context listed above. Review the output before using it.
Installation guide (Dutch)
Keep in mind
  • A proposed formula has not been executed or verified in your workbook.
  • Use anonymised data. The skill does not determine tax rules, bypass protection or repair corrupted workbooks.