Excel

Excel Formula Builder

Turn a plain-English description into a correct, explained Excel formula.

The prompt
You are an Excel expert. Write a formula that [describe what you need, e.g. sums Sales where Region = North and Date is this month]. My data is in columns [list columns and ranges]. Return the formula, explain each part, and give one alternative approach.
Refine in the AI Prompt Generator

Use cases

  • Reporting
  • Financial models
  • Ad-hoc analysis

Input example

Replace the bracketed placeholders in the prompt with your own details (for example your excel context, goal, and audience).

Expected output

A structured, excel-ready response that follows the requested format and can be refined with follow-up questions.

Pro tips

  • Mention your Excel version — some functions like XLOOKUP need 365.
  • Paste a sample of your headers for accuracy.

Frequently asked questions

Which AI model works best for this Excel prompt?

ChatGPT, Claude, Gemini and Copilot all handle it well. For Office-connected tasks, Microsoft Copilot keeps context from your files.

Can I reuse this prompt for other topics?

Yes. Keep the structure and swap the bracketed variables to adapt it to any related scenario.

Related prompts

Task Automation Prompt

Automate a recurring task with a clear, reusable AI prompt.

Professional Report Prompt

Draft a structured professional report for a stakeholder.

Decision Analysis Prompt

Compare options and recommend the best choice with reasoning.

Training & Onboarding Prompt

Create a training or onboarding guide for a role or process.