Spreadsheet insights
Excel & spreadsheets 9 min setup
Design an A/B test results workbook
Structure assignment, exposure, outcomes, exclusions, uncertainty, and decision rules without overstating a test
Open recipeTopics
AI prompts for data analysis and reliable insights
AI data analysis prompts for trends, outliers, segments, surveys, forecasts, charts, and executive summaries with explicit definitions and checks
A polished analysis can still be wrong when metrics, denominators, missing values, or time periods are unclear. These prompts start from the data contract and require reconciliation before interpretation.
How to use this collection
- Provide field definitions, units, time periods, missing-value rules, and known data limits.
- Separate descriptive patterns from causal claims and recommended actions.
Choose a recipe
23 recipesSpreadsheet insights
Excel & spreadsheets 10 min setup
Design a dashboard with defined metrics
Connect every dashboard number to a decision, population, formula, source, owner, refresh rule, and limitation
Open recipeSpreadsheet insights
Excel & spreadsheets 7 min setup
Compare segment performance in Excel
Compare groups using consistent metrics, denominators, coverage, and minimum sample rules
Open recipeSpreadsheet insights
Excel & spreadsheets 7 min setup
Choose mean, median, or quantiles for a spreadsheet metric
Match the summary statistic to the decision, metric scale, distribution, weighting, and tail risk
Open recipeSpreadsheet insights
Excel & spreadsheets 5 min setup
Choose the right chart for spreadsheet data
Match the comparison task and data shape to a chart without distorting scale or uncertainty
Open recipeCompare options
Shopping & product decisions 8 min setup
Check whether a promotion beats the regular offer
Normalize price, quantity, quality, fees, conditions, timing, rewards, returns, and unused volume before comparing savings
Open recipeSpreadsheet insights
Excel & spreadsheets 7 min setup
Calculate period and cumulative change in Excel
Compare complete periods with explicit baselines, denominators, and missing-period rules
Open recipeSpreadsheet 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 recipeSpreadsheet 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