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
Perplexity prompt templates for research and practical work
Explore Perplexity prompt templates for research questions, source checks, comparisons, writing, planning, and evidence-aware decisions
Use these templates to define the question, acceptable evidence, missing information, and desired output before working in Perplexity. Always open and verify consequential sources yourself. Test status is displayed separately from general portability.
How to use this collection
- Replace every visible placeholder before using a template in Perplexity.
- 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