The 'Excel Rescue' Prompt: How to Ask AI for the Right Formulas

Excel Doesn't Have to be Hard

We've all struggled with VLOOKUPs and nested IF statements. Instead of getting frustrated, use AI to write the formula for you based on a simple description of what you want to achieve. This works in ChatGPT, Gemini, and Claude.

The "Translator" Prompt

Instead of searching for a function, describe the goal: "I have a column A with sales figures and column B with categories. Write me an Excel formula that calculates the total sales only for the category 'Real Estate'."

Why This is a Game-Changer

The AI will not only give you the formula but will also explain how it works. This means you're learning while you're working. It's the perfect way to upskill your administrative team and ensure your business data is always accurate and well-organized.