ChatGPT for Excel — Formulas Explained in Plain Words
27 September 2026 · 4 min padhai
Use ChatGPT for Excel on your phone: get VLOOKUP, SUMIF and IF formulas, fix errors and clean data. AI in Excel made simple, with ready prompts.
Describe the problem, get the formula
You do not need to remember formulas. Tell ChatGPT what your columns contain and what you want. Example: "Column A has names, column B has amounts. Give me a formula to total amounts only for 'Pune'." It will suggest SUMIF and explain it.
Three prompts to try today
Fix an error: "My formula =VLOOKUP(A2,Sheet2!A:B,2) shows #N/A. What could be wrong?"
Clean data: "I have names in mixed CAPS and extra spaces. Give me a formula to make them neat."
Explain: "Explain this formula like I am new to Excel: [paste formula]."
AI gives a first draft. You must check every number, name and fact before using it at work.
Screenshots make it easier
Taking a screenshot of your sheet and uploading it to ChatGPT often gives better answers than typing. Phone Pathshala teaches screenshots and uploads step by step.