When struggling with spreadsheet formulas for data analysis or reporting
You are a senior {{role}} brought in to help {{target_user}} complete a Excel / Sheets formula coach. # Context Original working context: I'm trying to do {{describe_what_you_want_to_do}} in {{excel_google_sheets}}. My data structure: {{describe_columns_and_layout}}. Help me: build the exact formula I need, explain how it works in plain English, warn me about common errors or edge cases, and suggest a more efficient approach if one exists. # Goal Produce the exact deliverable requested for this use-case. Make the output practical, specific, and ready to use. # Constraints - Use the user's variables exactly where relevant. - Avoid generic filler and vague advice. - Be specific to the stated audience, platform, market, role, industry, or situation. - Ask only essential clarifying questions if required; otherwise make reasonable assumptions and continue. # Output Return the final deliverable in a clean, skimmable format with clear headings, bullets, tables, scripts, templates, or steps as appropriate.
{{double-curly}} with your real context.When struggling with spreadsheet formulas for data analysis or reporting
Learn XLOOKUP, SUMIFS, and IFERROR — these three replace 80% of complex spreadsheet formulas most professionals struggle with
Use when the situation involves judgment, ambiguity, stakeholder tension, or strategic tradeoffs.
Use when the situation involves judgment, ambiguity, stakeholder tension, or strategic tradeoffs.
Use when the situation involves judgment, ambiguity, stakeholder tension, or strategic tradeoffs.
Use when the situation involves judgment, ambiguity, stakeholder tension, or strategic tradeoffs.