Topics

Practical AI prompts for Excel formulas and spreadsheet work

Prompt templates for generating, explaining, repairing, and verifying Excel formulas without hiding assumptions or data problems

Spreadsheet formulas can look correct while referencing the wrong field, hiding missing matches, or mishandling blanks. These recipes start from the real workbook layout and require test cases before a formula is trusted.

How to use this collection

Provide exact headers, cell references, and representative values.
Verify generated formulas on normal, blank, and error cases before filling down.

Tested with real examples

Choose a recipe

Showing 25–28 of 28 recipes

Write & communicate 6 min setup

Turn spreadsheet analysis into an executive summary

Convert verified metrics into decisions, changes, risks, and requests without overstating evidence

A concise decision-ready summary with metric traceability and caveats

Open recipe

Organize information 7 min setup

Design a weekly sales tracker in Excel

Define activity, pipeline, outcomes, targets, and ownership without mixing their meanings

A maintainable input table, weekly summary, formulas, and review routine

Open recipe

Organize information 8 min setup

Design a budget-versus-actual tracker in Excel

Compare approved budget, actuals, commitments, and forecast with clear variance signs

A controlled budget model, variance formulas, forecast view, and reconciliation checks

Open recipe

Organize information 7 min setup

Design a project status and overdue task tracker

Track ownership, deadlines, dependencies, blockers, and overdue work with explicit status rules

A maintainable task table, overdue logic, project summary, and review routine

Open recipe