🔧 AI Prompt Library

3,112 ready-to-use AI prompts — copy, paste, and get results instantly.

Featured Prompts

3,112 prompts

excel VBA & Macros advanced

Excel VBA Macro Automation for Repetitive Reports

Write a VBA macro for Excel that automates the following repetitive reporting task: [describe task, e.g., pull data from Sheet1, format it, and paste into a summary Sheet2 with color-coded KPIs]. The macro should: 1) Run…

💡 Always back up your workbook before running macros. Test on a copy first. Use Alt+F11 to open the VB…

👁 23 views Open prompt →

email Meeting Management beginner

Email Declining a Meeting Request Professionally

Write a polite and professional email declining a meeting request for [reason, e.g., schedule conflict or not the right stakeholder]. The email should: 1) Thank the sender for the invitation, 2) Clearly but kindly declin…

💡 Never leave a meeting request unanswered. A short, warm decline is always better than silence. If un…

👁 23 views Open prompt →

writing Opinion & Thought Leadership intermediate

Op-Ed Writing Framework for Thought Leadership

Write an opinion editorial on the topic: [your topic]. Structure: 1) Hook opening that challenges a common assumption, 2) Clear thesis statement, 3) Three supporting arguments with evidence, 4) Acknowledge the strongest …

💡 Op-eds should challenge conventional wisdom, not confirm it. The counterargument section builds cred…

👁 23 views Open prompt →

writing Newsletter Writing intermediate

Newsletter Issue Writing Template for Niche Audience

Write a weekly newsletter issue for [newsletter name and niche]. Structure: 1) Personal opening note (2-3 sentences, conversational), 2) Main article or deep dive (400-500 words), 3) Quick hits section (3-5 curated links…

💡 Write your opening as if emailing a friend, not broadcasting. The closing question dramatically incr…

👁 23 views Open prompt →

coding Database advanced

PostgreSQL Database Indexing Strategy for Slow Queries

Analyze and fix slow query performance in PostgreSQL for [describe your schema and query]. Provide: 1) How to use EXPLAIN ANALYZE to identify bottlenecks, 2) Recommended index types (B-tree, composite, partial, GIN for J…

💡 Run EXPLAIN ANALYZE (not just EXPLAIN) to get real execution stats. Add indexes in production during…

👁 23 views Open prompt →

data Data Analysis intermediate

Python Pandas Advanced GroupBy and Aggregation Techniques

Demonstrate advanced Pandas GroupBy operations for [dataset type, e.g., sales transactions data]. Cover: 1) Multi-level groupby with multiple aggregation functions simultaneously, 2) Custom aggregation with transform and…

💡 Use named aggregations (pd.NamedAgg) for clearer column naming. groupby().transform() is key for add…

👁 23 views Open prompt →

excel Pivot Tables intermediate

Excel Pivot Table Design for Management Reporting

You are an Excel reporting expert. I need to build a professional pivot table report for management from raw data. My dataset has these fields: [list your columns, e.g., Date, Region, Product, Sales Rep, Revenue, Units, …

💡 List all column names exactly as they appear in your dataset. Mention if you need YoY or MoM compari…

👁 23 views Open prompt →

excel What-If Analysis advanced

Excel Scenario Manager and What-If Analysis Business Planning

You are a financial modeling expert using Excel. I need to build a what-if analysis model for business planning. My model involves: [describe the business decision, e.g., pricing model, headcount plan, capacity expansion…

💡 Name your scenarios descriptively (e.g., "Conservative 2026" not "Scenario 1"). Use Data Tables for …

👁 23 views Open prompt →

writing Blog Writing intermediate

Ghostwriting Blog Post from Bullet Points Brief

You are a professional ghostwriter and content strategist. I have a rough outline of ideas and I need you to transform them into a polished, publishable blog post that sounds like me. My voice: [describe your writing sty…

💡 Share 3 examples of your published writing so the ghostwriter can match your voice precisely. Mark w…

👁 23 views Open prompt →

business Crisis Management advanced

Crisis Communication Plan Template for Organizations

You are a crisis communications expert. I need to develop a comprehensive crisis communication plan for my organization. Our organization: [type: startup/enterprise/nonprofit], size [employee count], industry [your secto…

💡 Speed beats perfection in crisis: a "we are aware and investigating" message in 30 minutes beats a p…

👁 23 views Open prompt →

coding DevOps & Deployment intermediate

Docker Containerization for Python Flask Applications

You are a DevOps engineer specializing in containerization. I need to containerize my Python Flask application with Docker and Docker Compose. My application: [describe what it does]. Tech stack: Python [version], Flask,…

💡 Always use specific version tags (python:3.11-slim) not "latest" to ensure reproducible builds. Run …

👁 23 views Open prompt →

excel Data Validation beginner

Excel Data Validation: Drop-down Lists and Input Controls

Act as an Excel data integrity specialist. I need to set up data validation with drop-down lists and input controls in my spreadsheet. My situation: Sheet purpose: [e.g., employee expense submission form, inventory trac…

💡 Put all your list values on a hidden Lookups sheet and name each range. This makes managing and upda…

👁 23 views Open prompt →

data Data Management intermediate

Data Quality Assessment Framework and Cleaning Checklist

Act as a data quality engineer and analytics architect. Help me build a systematic data quality assessment and cleaning process. My context: Data source: [e.g., CRM export, database table, API response, CSV file] Data d…

💡 Profile your data before cleaning it. Understanding the actual distribution of bad data helps you wr…

👁 23 views Open prompt →

marketing Email Marketing intermediate

Email List Building: Lead Magnet Strategy Blueprint

Act as an email marketing strategist and growth expert. Help me build a systematic email list growth strategy using lead magnets. My context: Business type: [Your product, service, or content niche] Target subscriber: […

💡 The most effective lead magnets solve one specific problem in 10 minutes or less. Generic ultimate g…

👁 23 views Open prompt →

excel Power Query & Automation intermediate

Excel Power Query: Clean & Transform Raw Data Automatically

I have raw data in Excel that needs cleaning and transformation. Help me build a Power Query workflow to: [describe your data source and issues, e.g., multiple sheets with inconsistent formats, extra blank rows, merged c…

💡 Always load Power Query results into a Table, not a sheet range — it makes refresh and downstream fo…

👁 23 views Open prompt →

writing Video & Script Writing intermediate

YouTube Video Script: Tutorial and How-To Structure Template

Write a complete YouTube video script for a [length, e.g., 10-12 minute] tutorial on [topic]. Channel niche: [your niche]. Target viewer: [beginner/intermediate/advanced, describe their goal]. Structure: 1) Hook (first 1…

💡 The first 30 seconds determine whether viewers stay. Don't start with "Welcome back" or "Before we b…

👁 23 views Open prompt →

business Competitive Analysis intermediate

Competitor SWOT Analysis Deep-Dive Framework Template

Create a structured deep-dive SWOT analysis framework for competitive intelligence. Include: (1) Data collection sources for each quadrant (Strengths: G2/Capterra reviews, job postings, investor presentations; Weaknesses…

💡 Job postings are one of the best real-time competitive intelligence sources — they reveal strategic …

👁 23 views Open prompt →

creative Video & Script Writing intermediate

Video Ad Script Writing for Social Media Platform Templates

Write complete video ad scripts for multiple social media platforms and objectives. Provide: (1) TikTok/Reels 15-second product ad: hook in first 2 seconds, problem-solution-CTA structure, on-screen text overlay notes, (…

💡 The number one mistake in video ads is starting with the brand or product name — begin with the view…

👁 23 views Open prompt →

productivity Time Management intermediate

Time Blocking Schedule System Deep Work Productivity Framework

Design a complete time blocking system for knowledge workers to maximize deep work and minimize interruptions. Include: (1) Auditing your current time use: 2-week time audit methodology, categorizing tasks by energy type…

💡 Start with just one protected 2-hour deep work block per day before trying to overhaul your entire s…

👁 23 views Open prompt →

marketing Product Marketing advanced

Product Positioning Statement Writing Framework Differentiation Guide

Create a complete product positioning framework for SaaS and B2B companies. Cover: (1) Positioning vs. messaging vs. branding — clarifying the hierarchy and relationship, (2) The 6-element positioning framework: target c…

💡 The most valuable positioning insight usually comes from win/loss interviews — why customers chose y…

👁 23 views Open prompt →