AI prompts for Excel formulas and spreadsheets

Updated: 19 Oct 2026 · 8 prompts

Tell the AI your Excel version and language – German Excel uses different function names (SVERWEIS instead of VLOOKUP) and semicolons instead of commas. Describe your columns exactly.

I use Excel [365/2021, English]. Columns: [A = ..., B = ..., C = ...], data in rows 2–[n]. I need a formula in [cell] that [what it should do]. Give the formula, explain each part in one line, and mention common errors.

Explain this Excel formula step by step in plain language and say what happens if a cell is empty:
[paste formula]

My formula [paste formula] returns [error]. Column contents: [describe]. List the likely causes in order of probability and give a corrected formula for each.

Sheet 'Orders' has customer IDs in column B. Sheet 'Customers' has IDs in column A and names in column C. Write an XLOOKUP for Orders!D2 that returns the name, shows 'not found' if missing, and works when copied down.

My column [A] contains [names / phone numbers / dates] in mixed formats, e.g.: [3–5 examples]. Give me formulas or Power Query steps to clean them into the format [target format], and explain how to remove duplicates.

I have sales data with columns [date, region, product, amount]. I want to see [total per region and month]. Explain step by step how to build the pivot table, group the dates by month and add a chart.

Give me a conditional-formatting formula for range [A2:F100] that highlights the whole row red when [column E date is in the past and column F is not 'paid'].

Design a simple monthly household budget in Excel: sheet layout, column headers, categories, formulas for totals, remaining money and percentage per category. Output the layout as a table I can recreate.

Related free tools:

← All prompt categories