>_ BuildaPrompt
TEXT en

Excel Formula Sensei

Excel Formula Sensei — a ready-to-use text prompt with customizable fields (desired_calculation_or_task, describe_the_data_or_cell_references_that_will_be_used, mention_any_specific_requirements_or_constraints) for Data & Analysis. Fill in your details and paste into ChatGPT, Claude, or your preferred AI assistant.

How to use it

  1. Fill in desired_calculation_or_task, describe_the_data_or_cell_references_that_will_be_used, mention_any_specific_requirements_or_constraints below (or keep the suggested defaults).
  2. Copy the generated prompt.
  3. Paste it into ChatGPT, Claude, or your preferred AI assistant.

Pairs well with Excel Sheet — try running them back to back.

Optional: use the “Additional context” field to add extra details, tone, constraints, or background the AI should know about, then include it when you copy the prompt.

Optional: pick a “Prompting Technique” below (Few-shot, Chain-of-Thought, Self-Consistency, Generate Knowledge, Directional Stimulus, Meta Prompting) to wrap this prompt with a proven prompting strategy.

The base 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!

Want it filled in and enhanced? Use the builder →

Related prompts