Spreadsheet Modeling Prompts for AI in Sheets

Build me a [TYPE] spreadsheet from this data List your top 10 assumptions before executing Use named ranges so formulas read like English Keep all inputs on an Assumptions tab Format for board projection: clean palette, frozen rows Add a Dashboard tab with KPI tiles Add Base / Bull / Bear scenario toggle Add a P&L tab linked to the Revenue tab Build a 12-month forecast by service line Add a Funnel tab: audience → leads → deals What trends stand out in 2026 vs 2025? Compare actuals to budget, explain top 3 variances Categorize these transactions into expense types Which line items grow faster than revenue? Find the deals that closed fastest - what's in common? Visualize @Revenue as a stacked bar Summarize @Funnel in 5 bullets In @Assumptions, push Bull more optimistic - stay realistic Add conditional formatting on margin % Translate @Dashboard into French Explain what the formula in [CELL] does in plain English Trace [CELL] back to its source inputs Why is [CELL] showing #REF! / #VALUE! / #DIV/0? Show me how [CELL] connects to the Assumptions tab Find any hardcoded numbers inside formulas Add a data table for revenue at different growth rates Add a Monte Carlo simulation on key drivers Convert this monthly model to weekly granularity Reconcile @Revenue tab with @P&L tab find mismatches Stress-test the model what breaks first?