Topics
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.
Spreadsheet insights
Measure and visualize association while retaining time order, outliers, confounders, clustering, and alternative explanations
Open recipeSpreadsheet insights
Understand what a formula calculates, its dependencies, and where it can fail
Open recipeSpreadsheet insights
Turn a forecasting request into a testable analysis plan with baselines, time splits, leakage controls, uncertainty, and decision limits
Open recipeSpreadsheet insights
Track usable stock, demand, lead time, open supply, reorder logic, and exception ownership without inventing purchasing decisions
Open recipeSpreadsheet insights
Map a decision question to rows, columns, values, filters, and validation totals
Open recipeSpreadsheet insights
Structure assignment, exposure, outcomes, exclusions, uncertainty, and decision rules without overstating a test
Open recipeSpreadsheet insights
Define activity, pipeline, outcomes, targets, and ownership without mixing their meanings
Open recipeSpreadsheet insights
Track ownership, deadlines, dependencies, blockers, and overdue work with explicit status rules
Open recipeSpreadsheet insights
Connect every dashboard number to a decision, population, formula, source, owner, refresh rule, and limitation
Open recipeSpreadsheet insights
Track consent, ownership, last interaction, agreed next step, due date, and closure without manufacturing urgency or commitments
Open recipeSpreadsheet insights
Compare approved budget, actuals, commitments, and forecast with clear variance signs
Open recipeSpreadsheet insights
Inspect field meanings and define reversible cleaning rules before changing data
Open recipe
