NEW RELEASE

20 AI Prompts for Excel

Stop Googling Excel formulas. Paste these into ChatGPT, Claude, or Gemini — get instant working formulas, clean data, and smart spreadsheets.

What You Get

📄 Formulas

Write any formula from plain English

🧹 Data Cleaning

Fix messy data in one step

📊 Dashboards

Gantt charts, search boxes, filters

⚙️ VBA Macros

Buttons, auto-emails, automation

🔍 Lookups

VLOOKUP, XLOOKUP, multi-column returns

📅 Dates

Age calc, expiring dates, Gantt charts

Sample Prompts

Write a Formula: "Write an Excel formula for [what you want]. Use A1:A100 and B1:B100. Explain each part."

Clean Data: "I have data in column C with [issue]. Give me a formula to clean this."

Dynamic Dropdown: "Create a dropdown where options come from column E that grows over time."

Find Duplicates: "Find rows where columns A, B, C all match another row. Formula + highlight."

Conditional Format: "Highlight A2:A100 green if B says Yes. Exact formula."

...and 15 more prompts covering Gantt charts, pivot tables, loan calculators, VBA, and complex logic.

Why This Works

⏱️

Save Hours Per Week

Stop Googling. Each prompt is tested and ready to paste.

🤖

Works With Any AI

ChatGPT, Claude, Gemini, DeepSeek — all work perfectly.

📊

Real-World Use

Formulas, data cleaning, dashboards, VBA — all covered.

🔒

No Lock-In

PDF format. Works forever. No subscriptions.

How It Works

Download — Get the PDF instantly. 20 ready-to-use prompts.

Copy a Prompt — Pick the one that matches what you need in Excel right now.

Paste Into AI — Send it to ChatGPT, Claude, or any AI. Replace the bracketed parts.

Get Your Formula — The AI returns a working Excel formula. Copy it. Done.

FAQ

What AI tools does this work with?

All of them. ChatGPT, Claude, Gemini, DeepSeek, Perplexity — these prompts work with any language model. No special setup.

Do I need a specific version of Excel?

No. Prompts cover Excel 2010 through 365, with workarounds for older versions when a feature is version-specific.

Is this a subscription?

No. One payment. You own the PDF forever. No recurring charges, no accounts required on our end.

What format is it in?

PDF. Cleanly formatted, searchable, works on any device. Each prompt has a title, use case, the prompt text, and example output.

Will you add more prompts?

This is v1.0 with 20 core prompts. If there’s demand, volume 2 covers Power Query, macros, and advanced analytics.

Instant download · 20 prompts · PDF format

€3.00

Download Now

📄 8-page PDF · Works with ChatGPT, Claude, Gemini · No Excel version limits