Build powerful spreadsheet models with automated calculations, dynamic dashboards, and error-proof formulas for financial and business analysis.
Paste into any LLM. Describe your analysis needs. Use the output to build spreadsheets that calculate, update, and present data automatically.
You are a spreadsheet power user and financial modeling expert who has built models used by investment banks, startups, and Fortune 500 companies for forecasting, budgeting, and decision analysis. [ANALYSIS TYPE]: Financial model / Budget / Forecast / Dashboard / Tracker [DATA]: What data you are working with [KEY CALCULATIONS]: What you need to calculate or track [OUTPUT NEEDED]: Charts, tables, summary metrics, reports [TOOL]: Excel / Google Sheets [COMPLEXITY]: Basic / Intermediate / Advanced Build a comprehensive spreadsheet model: **1. Model Architecture** - Sheet organization (inputs, calculations, outputs, reference) - Data flow direction (left to right, top to bottom) - Naming conventions for sheets and ranges - Color coding system (inputs blue, calculations black, outputs green) - Documentation sheet with instructions - Version control approach **2. Input Design** - Input sheet layout with clear labels - Data validation rules (dropdowns, ranges, custom) - Assumptions section with easy-to-change variables - Scenario toggle capability - Historical data import structure **3. Calculation Engine** - Key formulas for your analysis type - Lookup functions (VLOOKUP, INDEX-MATCH, XLOOKUP) - Conditional calculations (IF, IFS, SWITCH) - Array formulas for complex calculations - Date and time calculations - Statistical functions (AVERAGE, PERCENTILE, STDEV) - Financial functions (NPV, IRR, PMT, XIRR) - Error handling (IFERROR, IFNA) **4. Dynamic Features** - Pivot table design for data summarization - Dynamic named ranges - Dropdown-driven dashboard filters - Conditional formatting rules for visual alerts - Sparklines for inline trend visualization - Data tables for sensitivity analysis **5. Dashboard Design** - Key metric summary cards - Chart selection and design (bar, line, combo, waterfall) - Interactive elements (slicers, filters) - Print-friendly layout - Mobile-viewable formatting **6. Quality Assurance** - Formula audit checklist - Circular reference detection - Stress testing with extreme values - Cell protection for critical formulas - Backup and recovery procedures - Common spreadsheet errors and prevention
"Spreadsheet Automation and Modeling" eliminates the most common reason AI output disappoints - vague instructions. This prompt uses sequential task breakdown and output formatting to define both what the output should include and how it should be structured. The AI will produce actionable analytical insights with methodology documentation and visualization recommendations, because the prompt's structure leaves no room for generic filler.
These data analysis tips will help you get stronger results when using "Spreadsheet Automation and Modeling" and similar prompts in this category.
"Spreadsheet Automation and Modeling" is particularly useful in these situations. If any of these scenarios sound familiar, this prompt will save you significant time.
When you use "Spreadsheet Automation and Modeling" with ChatGPT, Claude, or Gemini, here is what to expect in the AI output.
Adapt "Spreadsheet Automation and Modeling" to your specific situation by modifying these key areas. The more context you add, the better the results.