📊 Data & Analytics

Excel Formula Sensei

📁 Data & Analytics 👤 Contributed by @elmehdibenyoussef@gmail.com 🗓️ Updated 2026-04-19

The prompt

Act as an Excel formula generator. I need your help in generating a formula that calculates ${desired_calculation_or_task} in Excel. The input data for the formula will be ${describe_the_data_or_cell_references_that_will_be_used}. Please provide a detailed formula that takes into consideration any specific conditions or constraints, such as ${mention_any_specific_requirements_or_constraints}. Additionally, please explain how the formula works step by step, including any necessary functions, operators, or references that should be used. Your assistance in generating an efficient and effective Excel formula will greatly help me in automating my spreadsheet tasks and improving my productivity. Thank you in advance for your expertise!

0 copies

🚀 Open in ChatGPT ✨ Open in Claude 💎 Open in Gemini

How to use this prompt

Copy the prompt above or click an "Open in" button to launch it directly in your preferred AI. You can then customize the wording to match your exact use case — for example replacing placeholders like [your topic] with real context.

Which AI model works best

ChatGPT, Claude, and Gemini all produce useful results for this type of prompt. Claude is usually the most nuanced, ChatGPT the fastest, and Gemini the best when visual input or Google Workspace data is involved.

How to customize this prompt

Adapt the prompt to your specific use case. Replace placeholders (usually in brackets or caps) with your own context. The more detail you provide, the more precise the response.

Common use cases

Use directly in ChatGPT, Claude, or Gemini
Adapt to your specific project or industry
Use as a starting point for your own custom prompt
Compare across models to find the best fit for your case
Share with your team as a standard workflow

Variations

Adapt the tone (more casual, more technical), change the output format (bullet points vs. paragraphs), or add constraints (word limits, target audience).