🔧 AI Prompt Library

1,060 ready-to-use AI prompts — copy, paste, and get results instantly.

Featured Prompts

1,060 prompts

excel Pivot Tables & Analysis Advanced

Employee Performance Dashboard Pivot

Create a pivot table setup for employee performance analysis. Data columns: Employee Name, Department, Quarter, KPI Score, Projects Completed, Client Satisfaction Rating. Show how to: 1) Average KPI score by department, …

💡 Use slicers to make the dashboard interactive — much better than dropdown filters.

👁 8 views Open prompt →

excel VBA & Macros Advanced

Auto-Send Email Report VBA

Write an Excel VBA macro that: 1) Takes data from the active sheet, 2) Creates a formatted HTML email in Outlook, 3) Attaches the current workbook as a PDF, 4) Sends it to a specified email address. Include error handlin…

💡 Test with a DisplayEmail line first instead of Send to preview before auto-sending.

👁 8 views Open prompt →

excel VBA & Macros Advanced

Auto-Format New Data VBA

Write a VBA macro that automatically formats any new data pasted into an Excel sheet: 1) Auto-fit column widths, 2) Add borders to all cells with data, 3) Bold the header row, 4) Apply alternating row colors (light gray/…

💡 Assign this macro to a button on the sheet for one-click formatting.

👁 8 views Open prompt →

email Meeting Emails Beginner

Meeting Request Email

Write a professional email requesting a meeting. I want to meet with [person/team] to discuss [topic]. Preferred time: [date/time options]. The email should: 1) Clear subject line with the purpose, 2) Brief context (why …

💡 Always include an agenda. Meetings without agendas waste time.

👁 8 views Open prompt →

business Strategy Beginner

SWOT Analysis for Business

Create a SWOT analysis for [business/product]. Context: [brief description]. Generate: Strengths (5 internal positives), Weaknesses (5 internal negatives), Opportunities (5 external positives), Threats (5 external negati…

💡 Be brutally honest in Weaknesses and Threats. The value of SWOT is in the uncomfortable truths.

👁 8 views Open prompt →

creative Email Marketing Advanced

Email Newsletter Content Series

Design a 4-week email newsletter series for my audience. Business/Brand: [your business] Newsletter name: [name, if you have one] Audience: [who subscribes — e.g., "small business owners interested in AI"] Goal: [build …

💡 The best newsletters feel like emails from a smart friend, not a company. Write in first person. Kee…

👁 8 views Open prompt →

excel Automation Advanced

Invoice Generator with Auto-Numbering VBA

Create an Excel invoice generator with automatic invoice numbering using VBA. Business details: - Company name: [your company name] - Currency: [USD/EUR/GBP/IDR/etc.] - Tax rate: [e.g., 11% PPN] - Payment terms: [e.g., …

💡 Save the workbook as .xlsm to enable macros. Always test with sample data before using for real invo…

👁 8 views Open prompt →

hr Employee Engagement Intermediate

Employee Engagement Survey and Action Plan

Design a comprehensive employee engagement survey and action plan framework. Company size: [number of employees] Industry: [your industry] Current challenges: [e.g., high turnover, low morale, remote work issues] Last s…

💡 Guarantee anonymity — employees won't be honest otherwise. Share results transparently, even the bad…

👁 8 views Open prompt →

legal Contracts Intermediate

Freelance Contract Template

Create a comprehensive freelance/independent contractor agreement. I am the: [client hiring a freelancer / freelancer being hired] Service type: [web development/design/writing/consulting/etc.] Project: [brief project d…

💡 This is a starting template — have a lawyer review it for your jurisdiction before using it for high…

👁 8 views Open prompt →

legal Contracts Beginner

Non-Disclosure Agreement (NDA) Template

Create a Non-Disclosure Agreement (NDA) for my situation. Type: [Mutual (both parties share secrets) / One-way (only one party shares)] Purpose: [why you need it — e.g., "discussing potential partnership", "hiring a dev…

💡 Use mutual NDAs when both sides are sharing information — it's fairer and faster to negotiate. Be sp…

👁 8 views Open prompt →

excel Formatting Intermediate

Conditional Formatting Rules for KPI Dashboards

I need to set up conditional formatting in Excel for a KPI dashboard. My spreadsheet has these columns: - Column A: KPI Name - Column B: Target Value - Column C: Actual Value - Column D: % Achievement (formula: C/B) Ple…

💡 Replace the column references and threshold percentages with your actual layout. You can adjust the …

👁 8 views Open prompt →

coding DevOps Advanced

CI/CD Pipeline Configuration with GitHub Actions

Create a complete CI/CD pipeline using GitHub Actions for my project: - Project type: [e.g., 'Node.js REST API', 'Python Django app', 'React frontend'] - Testing framework: [e.g., 'Jest', 'pytest', 'Cypress'] - Deployme…

💡 Start with a simple pipeline and add complexity gradually. Use GitHub Actions marketplace for common…

👁 8 views Open prompt →

data Data Quality Advanced

Automated Data Quality Report with Anomaly Detection

Create a data quality monitoring report for my dataset: - Data source: [e.g., 'Sales database', 'CSV export from CRM'] - Key columns to monitor: [list columns and expected types] - Update frequency: [e.g., 'Daily', 'Wee…

💡 Schedule this to run automatically after each data load. Start with the most critical columns and ex…

👁 8 views Open prompt →

creative Email Marketing Intermediate

Email Marketing Campaign with A/B Test Variants

Design a complete email marketing campaign with A/B test variants: - Campaign goal: [e.g., 'Product launch', 'Re-engagement', 'Holiday sale', 'Webinar registration'] - Product/offer: [description] - Target segment: [e.g…

💡 Test one variable at a time in A/B tests. Send volume matters — you need at least 1,000 recipients p…

👁 8 views Open prompt →

creative Storytelling Beginner

Children's Story with Moral Lesson and Illustrations Guide

Write an original children's story with the following specifications: - Target age: [e.g., '5-8 years old'] - Moral/lesson: [e.g., 'It's okay to make mistakes — that's how we learn'] - Setting: [e.g., 'A magical forest'…

💡 Read the story aloud — children's books must sound good spoken. Keep sentences short and varied in r…

👁 8 views Open prompt →

hr Recruitment Intermediate

Competency-Based Interview Scorecard

Create a structured competency-based interview scorecard for evaluating candidates: - Role: [job title] - Department: [department] - Key competencies to assess: [e.g., 'Problem-solving, Communication, Leadership, Techni…

💡 Train all interviewers on the scorecard before using it. Score each competency independently — don't…

👁 8 views Open prompt →

customer-service Operations Intermediate

Customer Service Escalation Decision Tree

Create a customer service escalation decision tree for my support team: - Business type: [e.g., 'E-commerce', 'SaaS', 'Telecom'] - Support tiers: [e.g., 'Tier 1 (frontline), Tier 2 (specialist), Tier 3 (engineering), Ma…

💡 Review and update the decision tree quarterly based on actual escalation data. Empower Tier 1 to res…

👁 8 views Open prompt →

customer-service Onboarding Intermediate

Customer Onboarding Email Sequence for SaaS

Design a customer onboarding email sequence for a SaaS product: - Product: [name and what it does] - Target user: [e.g., 'Small business owners', 'Marketing teams', 'Developers'] - Trial period: [e.g., '14-day free tria…

💡 The best onboarding emails are triggered by behavior, not just time. If a user completes the key act…

👁 8 views Open prompt →

legal Data Privacy Advanced

Data Processing Agreement (DPA) for GDPR Compliance

Draft a Data Processing Agreement (DPA) that complies with GDPR requirements: - Data Controller: [your company name, country] - Data Processor: [vendor/service provider name, country] - Services provided by processor: […

💡 A DPA is legally required under GDPR Article 28 whenever you share personal data with a processor. R…

👁 8 views Open prompt →

productivity Knowledge Management Beginner

Personal Knowledge Management System (Second Brain)

Help me set up a Personal Knowledge Management system (Second Brain) using the PARA method: - Tool I'm using: [e.g., 'Notion', 'Obsidian', 'Logseq', 'Apple Notes'] - Main areas of my life/work: [list 3-5, e.g., 'Softwar…

💡 Start with just Projects and a daily capture note — don't build the perfect system on day one. The b…

👁 8 views Open prompt →