🔧 AI Prompt Library

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

Featured Prompts

1,110 prompts

excel Excel Formulas & Functions Intermediate

Excel VLOOKUP to XLOOKUP Migration: Formula Modernization Guide

I have existing Excel spreadsheets that use VLOOKUP formulas and I want to modernize them using XLOOKUP. Please help me: 1. Explain the key differences between VLOOKUP and XLOOKUP (return direction, approximate match, n…

💡 Specify your Excel version since XLOOKUP is only available in Excel 2019+ and Microsoft 365. Share a…

👁 6 views Open prompt →

excel Financial Modeling Beginner

Excel Personal Budget Tracker: Monthly and Annual Template

Help me build a comprehensive personal budget tracker in Excel from scratch. I need: 1. SHEET STRUCTURE: - Sheet 1: Monthly Dashboard (current month overview) - Sheet 2: Transaction Log (all income/expenses) - …

💡 Start by filling in the Category Setup sheet first before entering transactions. Use data validation…

👁 6 views Open prompt →

excel Project Management Intermediate

Excel Gantt Chart: Project Timeline and Milestone Tracker

I want to build a professional Gantt chart in Excel for project management without using add-ins or VBA. Please provide: 1. GANTT CHART STRUCTURE: - Column layout: Task ID, Task Name, Assigned To, Start Date, End Dat…

💡 Use custom number format to show only day numbers in timeline headers to save space. Consider using …

👁 6 views Open prompt →

writing Business Writing Intermediate

Executive Summary Writing: Business Report Structure Guide

Help me write a professional executive summary for a business report. Follow this structure: 1. SITUATION (1-2 sentences): What is the current state or problem being addressed? 2. COMPLICATION (1-2 sentences): What make…

💡 Write the executive summary last, after completing the full report. Always include at least one spec…

👁 6 views Open prompt →

business Strategy & Planning Intermediate

Customer Persona Template: ICP Framework for Market Research

Help me create detailed customer personas and an Ideal Customer Profile (ICP) for my business. I need: PART 1 - IDEAL CUSTOMER PROFILE (B2B or B2C): - Company/demographic attributes that define your best customers - Beh…

💡 Base personas on real customer interview data, not assumptions. Interview at least 5-10 current cust…

👁 6 views Open prompt →

business Project Management Intermediate

Stakeholder Management Communication Plan Template

Help me create a comprehensive stakeholder management and communication plan for my project. I need: 1. STAKEHOLDER MAPPING: - Stakeholder identification template (Name/Role/Organization/Interest/Influence) - Powe…

💡 Identify your most critical stakeholder first — the one who can kill the project — and invest most i…

👁 6 views Open prompt →

coding DevOps & Infrastructure Intermediate

Docker Compose: Multi-Service Application Setup and Configuration Guide

Help me set up a Docker Compose configuration for a multi-service application. I need: 1. DOCKER COMPOSE FILE STRUCTURE: Create a complete docker-compose.yml for an application with: - Web application service (spe…

💡 Always use named volumes for database data — anonymous volumes are lost on compose down. Use .env fo…

👁 6 views Open prompt →

coding Frontend Development Advanced

React Component Library: Setup with Storybook Documentation

Help me set up a React component library with Storybook documentation from scratch. I need: 1. PROJECT SETUP: - Folder structure for a component library - Package.json configuration (dependencies, scripts, exports…

💡 Start with the simplest component (Badge) to establish patterns before tackling complex ones. Docume…

👁 6 views Open prompt →

education Curriculum & Lesson Planning Intermediate

Project-Based Learning: Lesson Plan Template for K-12 and Higher Ed

Help me design a complete Project-Based Learning (PBL) unit plan. I need: 1. PROJECT OVERVIEW: - Driving Question: A real-world, open-ended question that frames the entire project - End Product: What students will…

💡 Start with the end product and work backwards to design the project. The driving question should be …

👁 6 views Open prompt →

hr Performance Management Advanced

Performance Improvement Plan (PIP): Writing Template for Managers

Help me write a Professional Performance Improvement Plan (PIP) that is clear, fair, and legally defensible. I need: 1. PIP STRUCTURE: - Employee information section - Purpose and context statement - Specific p…

💡 Always consult HR and legal before issuing a PIP. Document all coaching conversations BEFORE startin…

👁 6 views Open prompt →

legal Privacy & Data Compliance Intermediate

Privacy Policy Generator: GDPR and CCPA Compliance Template

Help me create a comprehensive privacy policy that complies with GDPR (EU) and CCPA (California). I need: 1. REQUIRED DISCLOSURE CHECKLIST: GDPR requirements: - Identity and contact details of data controller -…

💡 THIS IS NOT LEGAL ADVICE — have an attorney review before publishing. Update your privacy policy whe…

👁 6 views Open prompt →

legal Intellectual Property Intermediate

Software License Agreement: Types, Comparison, and Selection Guide

Help me understand software licensing and choose the right license for my project. I need: 1. LICENSE TYPE OVERVIEW: Open Source Licenses: - MIT License: permissions, conditions, limitations - Apache 2.0: vs MI…

💡 THIS IS NOT LEGAL ADVICE. GPL is "viral" — if you use GPL code in your project, your project must al…

👁 6 views Open prompt →

productivity Goal Setting & Planning Beginner

SMART Goal Setting: Annual Planning and Goal Achievement Framework

Help me create a comprehensive goal-setting and annual planning system using the SMART framework and beyond. I need: 1. GOAL SETTING FRAMEWORKS (compare and apply): - SMART goals: Specific, Measurable, Achievable, Re…

💡 The year-in-review is the most important step — skipping it means repeating last year's mistakes. Li…

👁 6 views Open prompt →

productivity Knowledge Management Intermediate

Zettelkasten Note-Taking: Personal Knowledge Management System

Help me set up and use a Zettelkasten personal knowledge management system. I need: 1. ZETTELKASTEN FUNDAMENTALS: - What is the Zettelkasten method (origin: Niklas Luhmann, who wrote 70+ books) - Core principle: i…

💡 Start with 10 notes before worrying about structure — the system emerges from use, not design. The v…

👁 6 views Open prompt →

marketing Paid Advertising Intermediate

Facebook Ads Campaign: Structure, Targeting, and Creative Guide

Help me set up an effective Facebook and Instagram ad campaign. I need: 1. CAMPAIGN STRUCTURE (Meta Ads Manager): Campaign level: - Objective selection guide: when to use Awareness/Traffic/Engagement/Leads/Sales/A…

💡 Start with broad targeting and let Meta's algorithm find your audience — overly specific targeting l…

👁 6 views Open prompt →

finance Expense Management Beginner

Expense Report Template: Policy Design and Reimbursement Guide

Help me create a comprehensive company expense report system. I need: 1. EXPENSE POLICY DESIGN: - Expense categories and per-diem rates: * Travel (flights, hotels, ground transportation) * Meals (per person…

💡 Set spending limits slightly higher than reality — overly restrictive limits breed workarounds and r…

👁 6 views Open prompt →

design UX/UI Design Intermediate

Mobile App Wireframe: UX Flow Documentation and Screen Mapping

Help me create comprehensive wireframe documentation and UX flow maps for a mobile app. I need: 1. UX FLOW MAPPING: - User journey identification (list all main user flows) - Flow diagram notation: screens, decisi…

💡 Start with the happy path only — document error states after the core flow is approved. Low-fidelity…

👁 6 views Open prompt →

design Design Process & Strategy Advanced

Design Sprint: 5-Day Facilitation Guide and Workshop Template

Help me plan and facilitate a 5-day Design Sprint following the Google Ventures methodology. I need: 1. SPRINT OVERVIEW: - What a Design Sprint is and when to use it - Ideal team composition (6-7 people, Decider r…

💡 The most common sprint failure is an unclear challenge statement — spend time on the Long-Term Goal …

👁 6 views Open prompt →

writing Academic Writing Advanced

Research Paper Outline: Literature Review and Methodology Structure Guide

Help me create a comprehensive outline for an academic research paper. I need: 1. PAPER STRUCTURE OVERVIEW: - Title page conventions for my citation style (APA/MLA/Chicago) - Abstract: what to include and what to …

💡 Start writing the methodology section first — it is the most concrete and gives momentum. Write the …

👁 6 views Open prompt →

coding Backend Development Intermediate

Node.js Express API: CRUD Operations with Authentication Boilerplate

Help me build a production-ready Node.js REST API with Express. I need a complete boilerplate with: 1. PROJECT STRUCTURE: - Folder organization: routes/, controllers/, middleware/, models/, config/, utils/ - Entry…

💡 Use async/await with a global error handler — never let unhandled promise rejections crash your serv…

👁 6 views Open prompt →