Prompt Library.

Create an Excel formula for:

**What I need:** [DESCRIBE CALCULATION]
**Data layout:** [DESCRIBE WHERE DATA IS - columns, rows]
**Conditions:** [ANY IF/FILTER CONDITIONS]
**Expected output:** [WHAT THE RESULT SHOULD LOOK LIKE]

Provide:
1. The exact formula (ready to paste)
2. Step-by-step explanation of how it works
3. Example with sample data
4. Common errors and how to fix them
5. Alternative approach (if applicable)

Analyze this data and provide insights:

[PASTE DATA OR DESCRIBE DATASET]

**Analysis Goals:** [WHAT YOU WANT TO LEARN]
**Context:** [BUSINESS/PROJECT CONTEXT]

Provide:
1. **Summary Statistics** - key metrics overview
2. **Trends** - patterns over time
3. **Anomalies** - outliers or unexpected values
4. **Correlations** - relationships between variables
5. **Visualizations** - describe 3 charts that would best represent findings
6. **Key Insights** - 5 actionable takeaways
7. **Recommendations** - what to do based on the data
8. **Python/SQL Code** - queries to reproduce this analysis

Generate a compelling story plot:

**Genre:** [Sci-fi / Fantasy / Thriller / Romance / Mystery]
**Length:** [Short story / Novella / Novel]
**Theme:** [e.g., redemption, identity, power]
**Setting:** [WHERE and WHEN]

Provide:
1. **Logline** (1 sentence pitch)
2. **Main Character** - name, age, flaw, goal, motivation
3. **Antagonist** - who/what opposes them
4. **Three-Act Structure:**
   - Act 1: Setup + Inciting Incident
   - Act 2: Rising Action + Midpoint Twist
   - Act 3: Climax + Resolution
5. **Key Scenes** (5 pivotal moments)
6. **Opening Line** (hook the reader)

Create 5 detailed AI image generation prompts for:

**Subject:** [WHAT YOU WANT]
**Style:** [Photorealistic / Illustration / Abstract / Anime / Oil Painting]
**Mood:** [Happy / Dark / Professional / Dreamy / Energetic]
**Use Case:** [Blog header / Social media / Product / Art]

For each prompt include:
- Full prompt text (ready to copy-paste)
- Negative prompt (what to exclude)
- Recommended settings (aspect ratio, style)
- Which AI tool works best for this prompt (Midjourney/DALL-E/Flux)

Make prompts specific with lighting, camera angle, color palette details.

Generate a comprehensive keyword research report for:

**Seed Keyword:** [KEYWORD]
**Industry:** [INDUSTRY]
**Content Goal:** [Blog / Product Page / Landing Page]

Provide:
1. **Primary Keywords** (5) - high volume, main targets
2. **Long-tail Keywords** (10) - 4+ words, lower competition
3. **Question Keywords** (5) - what/how/why/can queries
4. **LSI Keywords** (10) - semantically related terms
5. **Search Intent** for each keyword: Informational / Commercial / Transactional
6. **Content Ideas** - 5 article titles targeting these keywords
7. **Competitor Gap** - keywords competitors rank for that you likely don't

Optimize this article for SEO:

**Target Keyword:** [KEYWORD]
**Current Title:** [TITLE]
**Article:** [PASTE CONTENT]

Provide:
1. **Optimized Title** (under 60 chars, keyword near front)
2. **Meta Description** (under 155 chars, includes keyword + CTA)
3. **H2 Headings** (5-6 keyword-rich section headings)
4. **Internal Link Suggestions** (3-5 related topics to link to)
5. **Missing Topics** (subtopics competitors cover that you don't)
6. **Keyword Density Check** (current vs recommended)
7. **Featured Snippet Opportunity** (rewrite a section as Q&A format)

Create a study guide for:
**Subject:** [SUBJECT]
**Topic:** [TOPIC]
**Level:** [Beginner / Intermediate / Advanced]

Include:
1. **Key Concepts** - definitions and explanations
2. **Important Formulas/Rules** (if applicable)
3. **Visual Aid** - describe a diagram or flowchart
4. **Example Problems** with step-by-step solutions (3)
5. **Practice Questions** (5 with answers)
6. **Common Mistakes** to avoid
7. **Memory Tricks** - mnemonics or associations
8. **Quick Reference** - one-page summary

Create a detailed lesson plan:

**Subject:** [SUBJECT]
**Topic:** [SPECIFIC TOPIC]
**Grade/Level:** [LEVEL]
**Duration:** [MINUTES]
**Learning Objectives:** [WHAT STUDENTS WILL LEARN]

Include:
1. **Warm-up** (5 min) - engagement activity
2. **Introduction** (10 min) - key concepts
3. **Main Activity** (20 min) - hands-on learning
4. **Practice** (10 min) - individual/group work
5. **Assessment** - how to check understanding
6. **Wrap-up** (5 min) - summary + homework
7. **Materials needed**
8. **Differentiation** - adaptations for different levels

Write a business proposal for:
**Service/Product:** [WHAT]
**Client:** [WHO]
**Problem they face:** [PAIN POINT]
**Your solution:** [HOW YOU SOLVE IT]
**Timeline:** [DURATION]
**Budget range:** [AMOUNT]

Structure:
1. Executive Summary (2-3 sentences)
2. Problem Statement
3. Proposed Solution (with methodology)
4. Deliverables (bulleted list)
5. Timeline with milestones
6. Investment (pricing breakdown)
7. Why Us (3 differentiators)
8. Next Steps

Tone: Professional, confident, client-focused.

Perform a comprehensive SWOT analysis for:

**Company/Project:** [NAME]
**Industry:** [INDUSTRY]
**Stage:** [Startup / Growing / Established]
**Key Competitors:** [LIST 2-3]

Format:

## Strengths (Internal Positives)
- [5 specific strengths with brief explanation]

## Weaknesses (Internal Negatives)
- [5 specific weaknesses]

## Opportunities (External Positives)
- [5 market opportunities]

## Threats (External Negatives)
- [5 threats]

## Strategic Recommendations
Based on this analysis, recommend 3 actionable strategies.

Write landing page copy for:
**Product:** [NAME]
**Value Proposition:** [ONE SENTENCE]
**Target Customer:** [WHO, their pain points]
**Price:** [AMOUNT]

Sections needed:
1. Hero: Headline + subheadline + CTA button text
2. Problem: 3 pain points the audience faces
3. Solution: How your product solves each pain point
4. Features: 4-6 features with benefit-focused descriptions
5. Social Proof: Testimonial template + stats section
6. FAQ: 5 common objections answered
7. Final CTA: Closing headline + button text

Tone: Confident, clear, zero jargon.

Write ad copy for:
**Product/Service:** [NAME]
**Platform:** [Google Ads / Facebook / Instagram / LinkedIn]
**Target Audience:** [WHO]
**Key Benefit:** [MAIN VALUE PROP]
**Budget Level:** [Low/Medium/High]

Generate 3 variations:
1. **Emotional** - focus on feelings and transformation
2. **Logical** - focus on features, data, ROI
3. **Urgency** - focus on FOMO and limited availability

Each variation needs: Headline (under 30 chars), Description (under 90 chars), CTA.