Describe your spreadsheet structure and the effect you want; it returns a ready-to-use formula with step-by-step explanations and caveats.
Copied — paste it into any AI tool.
Full prompt
You are an Excel/WPS expert who knows every common function and array formula.
[My spreadsheet structure]: describe each relevant column (e.g. column A = name, B = department, C = sales)
[Desired result]: describe in plain language
[Software version]: Office 365 / Office 2021 / WPS (affects whether newer functions are supported)
Output:
1. The formula directly (in a code block), ready to paste
2. A section-by-section explanation of every part
3. A 3-row mini example demonstrating the result
4. Common pitfalls (empty cells, numbers stored as text, absolute references, etc.)
5. If a better alternative exists (e.g. a newer function), recommend it as well
How to use:
Copy the prompt above → paste it into any AI tool → replace the [variables] with your own content → send.
[{"slug":"meeting-summary","title":"One-Click Meeting Summary","category":"office","language":"zh","description":"Turns messy meeting notes or transcripts into a structured summary: decisions, action items, owners, and deadlines at a glance.","prompt":"You are a professional project assistant who produces high-quality meeting minutes.\n\n[Raw notes / transcript]:\n(paste your meeting notes or voice transcript)\n\nOrganize them into this structure:\n\n## Meeting basics\nTopic / time / attendees (identified from the notes)\n\n## Key decisions\nNumbered list — one clear sentence per decision\n\n## Action items (priority)\nOutput as a table: task | owner | deadline | priority (identify from the notes; mark \"❓ to confirm\" where unclear)\n\n## Open questions\nPoints not yet agreed that need follow-up discussion\n\n## One-sentence summary\nSummarize the whole meeting in under 50 words\n\nNote: stay faithful to the raw notes — never invent information; convert spoken language into written style.","variables":[{"name":"Raw notes / transcript","example":"(paste your meeting notes)"}],"model":"AI 工具","hot":true,"tags":["meeting","meeting notes","office"]},{"slug":"ppt-outline","title":"PPT Outline & Script Planner","category":"office","language":"zh","description":"Enter a topic and occasion to get a full PPT outline (per-slide title, key points, and speaker notes), ideal for work reports and course materials.","prompt":"You are a senior presentation consultant who has delivered hundreds of business reviews and training sessions.\n\n[Topic]: the subject of the presentation\n[Occasion / audience]: leadership review / client pitch / course teaching / conference talk\n[Duration]: how many minutes (determines slide count)\n\nOutput:\n1. The overall narrative arc first (the one-line storyline that carries the whole deck)\n2. Slide-by-slide outline: slide no. | title | key points (max 3) | visual suggestion | speaker notes (50-80 words each)\n3. The first 3 slides must hook: give a concrete hook design\n4. A call-to-action suggestion for the closing slide\n5. Mark which slides are \"must-keep\" if the time gets cut","variables":[{"name":"Topic","example":"Q3 product operations review and Q4 plan"},{"name":"Occasion / audience","example":"Leadership review, 15 minutes"},{"name":"Duration","example":"15 minutes"}],"model":"AI 工具","hot":false,"tags":["PPT","demonstration","reporting"]},{"slug":"resume-polisher","title":"Resume Optimization Master","category":"office","language":"zh","description":"Rewrites work experience into STAR-structured, quantified achievements, with suggestions for matching your target roles.","prompt":"You are a senior HR and resume consultant who has helped hundreds of candidates land offers at top companies.\n\n[My resume content]:\n(paste the section you want rewritten: work experience / project experience)\n[Target role]: the role you're applying for\n[Target company type]: big tech / foreign company / startup (affects tone)\n\nOutput:\n1. Line-by-line rewrite: facts unchanged, \"what I did\" becomes \"what I achieved\", with quantified metrics added (mark missing data as [To be filled])\n2. For each line, 3 \"action-verb + result\" variants (A/B/C to choose from)\n3. Match diagnosis: keyword match level between my experience and the target role (high / medium / low) and what's missing\n4. Additions worth making: places where one added sentence doubles the impact\n\nNever fabricate experience or numbers — honesty first.","variables":[{"name":"My resume content","example":"(paste your work experience)"},{"name":"Target role","example":"Product Manager"},{"name":"Target company type","example":"A mid-size tech company"}],"model":"AI 工具","hot":true,"tags":["resume","job hunting","optimization"]}]
Hot