✅Formula Building
Prompt: “Sales in B, dates in A. I need a rolling 90-day average that ignores blanks—use LET/LAMBDA, add 2 sample rows, and a brief explanation.”
✅Data Crunching
Prompt: “Upload sales.xlsx. Clean nulls, run regression: Revenue vs Ads. Return coefficients, key headline per region, and the edited file.”
✅Charts & Visuals
Prompt: “Compare monthly spend across departments. Suggest best chart, axis labels, gridlines, and write a 2-line caption showing biggest drop.”
✅Macros & Automation
Prompt: “Write VBA to hide rows with blank column F. Add inline comments, place it in the right module, and recommend Ctrl+Shift shortcut.”
✅Error Fixes
Prompt: “=SUM(A1:A10,B1:B10) gives VALUE! error. Fix it with a reliable formula, and suggest one validation rule to avoid this in future.”
✅Learning Help
Prompt: “What are the top YouTube channels for mastering Excel formulas/functions?”
✅Speed Tricks
Prompt: “Customer comments are in column B. Categorize as Positive/Neutral/Negative using a spill range. Include mnemonic for Alt H O I + a quick 3-item checklist.”
✅Data Cleaning with Power Query
Prompt: “Change ‘12-Mar-24’ to 2024-03-12, strip out $, and convert blanks to 0—only M code, with one-liner notes per step.”
✅Excel Best Practices
Prompt: “Give me 5 rules for workbook hygiene, a standard comment format for cells, and a yes/no audit table for review sign-off.”
✅Prompting Like a Pro
Prompt: “You are ExcelGPT, a precise Excel expert. Read the task, give the minimal working formula/code first, test 2 edge cases, no fluff unless asked.”
♻️ Repost this to help more people prompt smarter in Excel.
Follow Aditya Kachave for AI + Productivity hacks you can actually use.
This post was originally shared by on Linkedin.