Spreadsheet insights
Combine Excel columns with explicit blank rules
Join fields without stray separators, lost zeroes, collapsed distinctions, or silently changed missing values
Open recipeAI tools
ChatGPT prompt templates for practical work
Browse reusable ChatGPT prompt templates for writing, analysis, planning, learning, Excel, meetings, and everyday tasks, with examples and result checks
Use these structured templates in ChatGPT when a short request is not enough. Every recipe makes inputs, constraints, expected output, and review checks visible. A test badge identifies recipes with a recorded ChatGPT run; other recipes are model-portable templates that still require review.
How to use this collection
- Replace every visible placeholder before using a template in ChatGPT.
- Review facts, calculations, sources, and consequential decisions outside the model.
Choose a recipe
318 recipesSpreadsheet insights
Clean Excel dates and calculate a duration
Normalize mixed date inputs before calculating calendar or working time
Open recipeSpreadsheet insights
Build an Excel conditional summary formula
Create a SUMIFS, COUNTIFS, or AVERAGEIFS formula from explicit criteria
Open recipeSpreadsheet insights
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
Choose between VLOOKUP, XLOOKUP, and INDEX/MATCH
Select a lookup pattern from workbook compatibility, match behavior, layout, maintainability, and data risk
Open recipeCompare options
Check whether a promotion beats the regular offer
Normalize price, quantity, quality, fees, conditions, timing, rewards, returns, and unused volume before comparing savings
Open recipeStudy smarter
Check understanding with the teach-back method
Test whether a learner can explain, apply, and repair a concept without copying the source
Open recipeStudy smarter
Check understanding with Socratic questions
Probe definitions, reasoning, evidence, boundaries, and transfer one question at a time without supplying the answer
Open recipeSpreadsheet insights
Calculate period and cumulative change in Excel
Compare complete periods with explicit baselines, denominators, and missing-period rules
Open recipeUser insights
Build prioritization criteria for feature requirements
Define evidence-based feature criteria, gates, scales, uncertainty, dependencies, and decision rules before scoring candidates
Open recipeEveryday planning
Build comparison criteria for a shared family decision
Turn different household needs, constraints, evidence, and decision rights into fair criteria before comparing options
Open recipeBusiness essentials
Build evaluation criteria for a procurement comparison
Translate business needs, risks, and constraints into observable vendor evaluation criteria before reviewing offers
Open recipe