Spreadsheet insights
Excel & spreadsheets 7 min setup
Audit a chart for misleading design
Review scale, encoding, labels, missing context, and the claim against source values
Open recipeTopics
AI prompts for Excel formulas and spreadsheet work
Excel prompt templates for formulas, lookups, data cleaning, workbook design, analysis, charts, validation, and troubleshooting
Spreadsheet outputs can look correct while referencing the wrong field, hiding missing matches, or breaking on blanks. These recipes start from the real workbook layout and require representative tests before a result is trusted.
How to use this collection
- Provide exact sheet names, headers, cell references, data types, and representative rows.
- Test normal, blank, duplicate, unmatched, and error cases before filling down.
Choose a recipe
40 recipesSpreadsheet insights
Excel & spreadsheets 7 min setup
Analyze trends in spreadsheet data
Separate sustained change, seasonality, and one-off noise using explicit time periods
Open recipeSpreadsheet insights
Excel & spreadsheets 8 min setup
Analyze survey ratings and comments in Excel
Combine rating distributions with traceable comment themes and response-bias limits
Open recipeSpreadsheet insights
Excel & spreadsheets 7 min setup
Analyze missing values in Excel
Measure missingness by field and group before deciding whether to leave, recover, or exclude it
Open recipe