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
Qwen prompt templates for practical work and learning
Explore Qwen prompt templates for writing, analysis, spreadsheets, teaching, planning, business tasks, and personal productivity
Adapt these task-centered templates for Qwen by supplying your real context and checking the stated result criteria. Compatibility is treated as a starting point, while recorded Qwen tests are identified explicitly.
How to use this collection
- Replace every visible placeholder before using a template in 通义千问.
- 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