Organize information 6 min setup
Standardize category labels in Excel
Map known label variants to an approved vocabulary while exposing unknown values
An auditable mapping table, lookup formula, and unmapped-value review queue
Open recipeTopics
Practical AI prompts for Excel formulas and spreadsheet work
Prompt templates for generating, explaining, repairing, and verifying Excel formulas without hiding assumptions or data problems
Spreadsheet formulas can look correct while referencing the wrong field, hiding missing matches, or mishandling blanks. These recipes start from the real workbook layout and require test cases before a formula is trusted.
How to use this collection
- Provide exact headers, cell references, and representative values.
- Verify generated formulas on normal, blank, and error cases before filling down.
Tested with real examples
Choose a recipe
Organize information 7 min setup
Analyze missing values in Excel
Measure missingness by field and group before deciding whether to leave, recover, or exclude it
A missingness profile, decision rules, and impact checks without invented values
Open recipeOrganize information 7 min setup
Audit Excel headers, field definitions, and data types
Compare a workbook with its intended schema before import, analysis, or automation
A schema dictionary, conformance report, and row-level validation plan
Open recipeResearch 6 min setup
Generate useful analysis questions for a spreadsheet
Turn a dataset and decision into questions its fields can actually answer
A prioritized analysis question set with fields, methods, and limits
Open recipeResearch 7 min setup
Analyze trends in spreadsheet data
Separate sustained change, seasonality, and one-off noise using explicit time periods
A reproducible trend table, chart plan, and evidence-bounded interpretation
Open recipeResearch 7 min setup
Find and investigate spreadsheet outliers
Flag unusual values with a method suited to the distribution, then investigate before removal
Transparent outlier flags, context checks, and keep-correct-remove decisions
Open recipeResearch 7 min setup
Calculate period and cumulative change in Excel
Compare complete periods with explicit baselines, denominators, and missing-period rules
Verified change formulas, comparison table, and boundary checks
Open recipeResearch 7 min setup
Compare segment performance in Excel
Compare groups using consistent metrics, denominators, coverage, and minimum sample rules
A fair segment comparison with volume, rates, uncertainty, and diagnostic next steps
Open recipeResearch 8 min setup
Analyze survey ratings and comments in Excel
Combine rating distributions with traceable comment themes and response-bias limits
A mixed-method survey summary with counts, themes, evidence, and unsupported claims
Open recipeOrganize information 6 min setup
Design an Excel PivotTable for a business question
Map a decision question to rows, columns, values, filters, and validation totals
A reproducible PivotTable layout with calculations, filters, and reconciliation checks
Open recipeOrganize information 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
A chart recommendation, data layout, labeling rules, and rejected alternatives
Open recipeThink & decide 7 min setup
Audit a chart for misleading design
Review scale, encoding, labels, missing context, and the claim against source values
A severity-ranked chart audit and a corrected design specification
Open recipe