Build an XLOOKUP between Excel sheets
Join two sheets with an explicit key, match rule, and no-match behavior
A verified lookup formula plus duplicate and data-quality checks
Open recipeAI tools
Grok prompt templates for structured AI tasks
Use practical Grok prompt templates for research planning, content, communication, decisions, learning, and recurring work
These model-portable recipes help frame a complete request for Grok with explicit inputs and verification steps. They are not claims about current product features or output quality; a test badge appears only where a Grok run has been recorded.
How to use this collection
- Replace every visible placeholder before using a template in Grok.
- Review facts, calculations, sources, and consequential decisions outside the model.
Choose a recipe
318Build an Excel conditional summary formula
Create a SUMIFS, COUNTIFS, or AVERAGEIFS formula from explicit criteria
A criteria-safe summary formula with date, blank, and range checks
Open recipeBuild a source-aware research plan
Plan what to investigate, where to look, and how to separate evidence from inference
A research plan with questions, source hierarchy, and evidence rules
Open recipeBuild a resume skills section from job requirements
Select defensible skills and labels from requirement-to-evidence mapping instead of copying keywords
A grouped skills section with evidence level, omissions, and interview verification notes
Open recipeBuild a realistic exam revision schedule
Allocate limited study time by exam date, importance, current mastery, energy, and uncertainty
A dated revision schedule with active practice, buffers, fallback rules, and progress checks
Open recipeBuild a project risk register
Convert uncertain events into owned, evidence-based risks with triggers, responses, and review dates
A prioritized risk register with scoring rationale, response actions, contingencies, and gaps
Open recipeBuild a new-employee onboarding plan
Sequence access, relationships, learning, supervised practice, and evidence of readiness without assuming instant productivity
A dated onboarding plan with owners, prerequisites, milestones, safeguards, feedback loops, and contingency paths
Open recipeBuild a multi-condition Excel IF formula
Turn ordered business rules into a formula with explicit precedence and edge cases
A reviewable IF or IFS formula with a decision table and tests
Open recipeBuild a family weekly plan around work, care, and rest
Coordinate household commitments, care handoffs, preparation, and protected recovery without double-booking anyone
A shared weekly schedule with handoffs, load balance, buffers, and fallback rules
Open recipeBuild a balanced weekly plan
Allocate a finite week across work, family, care, health, rest, and uncertainty
A capacity-balanced weekly map with priorities, buffers, boundaries, and adjustment rules
Open recipeBreak a project goal into milestones and tasks
Decompose an outcome into verifiable milestones, deliverable-sized tasks, dependencies, and gaps
A dependency-aware work breakdown with acceptance evidence and ownership gaps
Open recipeBreak a procrastinated task into easy starting steps
Reduce ambiguity and activation cost without diagnosing motivation or trivializing real barriers
A tiny first action, short launch sequence, barrier responses, and restart plan
Open recipe