🔧 AI Prompt Library

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

Featured Prompts

910 prompts

Excel Analysis Intermediate

Data Analysis Report Template

Design a data analysis report template in Excel for [DATA TYPE]. Include: executive summary dashboard, data tables with filters, pivot table setup, chart recommendations, key metrics calculations, and anomaly highlightin…

💡 Use conditional formatting for visual cues. Include data validation rules.

👁 8 views Open prompt →

Excel Project Management Intermediate

Project Timeline Gantt Chart

Design an Excel-based Gantt chart template for project tracking. Include: task list, start/end dates, dependencies, progress percentage, resource assignment, milestone markers, and automatic timeline visualization.

💡 Use conditional formatting for color coding. Include critical path calculation if possible.

👁 8 views Open prompt →

Legal Compliance Intermediate

Privacy Policy Generator

Create a privacy policy template for [BUSINESS TYPE] that covers: data collection, usage, storage, sharing, user rights, cookies, third-party services, security measures, and contact information. Include GDPR and CCPA co…

💡 Have legal counsel review. Update when data practices change.

👁 8 views Open prompt →

coding testing Intermediate

ChatGPT prompt for generating Python unit tests for an existing function

Act as a senior Python test engineer who follows best practices for pytest. I have a function that I need comprehensive unit tests for. Here is the function: ```python [paste your function here] ``` Dependencies/conte…

💡 Paste the full function including imports and type hints. If the function depends on other functions…

👁 8 views Open prompt →

productivity time management Beginner

ChatGPT prompt for building a personal productivity system using time blocking

Act as a productivity coach who has studied deep work, time management, and energy management frameworks. Help me design a personalized time-blocking productivity system. My situation: - Role: [your job title / student…

💡 Be honest about your actual habits, not your ideal ones. The system should work for your real life. …

👁 8 views Open prompt →

excel dashboards intermediate

Build a Dynamic KPI Dashboard in Excel

Create a dynamic KPI dashboard in Excel for [business/department]. The dashboard should include: (1) Key metrics: [list 5–8 KPIs relevant to your context], (2) Trend charts with conditional formatting to highlight above/…

💡 Start by listing your 5 most important KPIs before asking. Use named ranges to make formulas easier …

👁 8 views Open prompt →

business strategy intermediate

Business Model Canvas for a Startup

Help me complete a Business Model Canvas for my startup idea: [describe your product/service in 2–3 sentences]. Fill in all 9 blocks: (1) Customer Segments — who are our most important customers? (2) Value Propositions —…

💡 The Business Model Canvas is a hypothesis, not a plan. Focus on identifying your riskiest assumption…

👁 8 views Open prompt →

data analytics advanced

Statistical Analysis of Survey Results

Help me analyze survey results from [survey topic]. Survey details: [number] respondents, [number] questions, question types: [Likert scale / multiple choice / open text]. Provide: (1) Descriptive statistics for Likert-s…

💡 Check response bias: who did not respond and why? Clean data before analysis — watch for straight-li…

👁 8 views Open prompt →

creative content intermediate

Podcast Episode Script in Interview Format

Write a podcast episode script for [podcast name/theme] featuring an interview with [guest persona or actual guest]. Episode topic: [topic]. Target audience: [audience description]. The script should include: (1) Host in…

💡 Record a pre-interview conversation to find the best 3 stories your guest tells naturally. The best …

👁 8 views Open prompt →

customer-service onboarding advanced

Customer Success Onboarding Playbook

Create a customer onboarding playbook for [product/service type] targeting [customer segment — SMB / enterprise / consumer]. The playbook should cover: (1) Onboarding goals and success metrics (time-to-value, activation …

💡 Define "successful onboarding" with a specific activation metric before building the playbook (e.g.,…

👁 8 views Open prompt →

marketing email intermediate

Email Marketing Drip Campaign Sequence

Write a 7-email drip campaign sequence for [product/service] targeting [audience segment — new subscribers / trial users / leads who downloaded a lead magnet]. Campaign goal: [convert to paid / nurture to demo request / …

💡 Personalize beyond first name — reference the lead magnet they downloaded or the page they visited. …

👁 8 views Open prompt →

design branding intermediate

Brand Identity Guidelines and Visual Language

Help me create brand identity guidelines for [brand name], a [description of company/product]. Brand personality: [3–5 adjectives — e.g., bold, trustworthy, innovative, playful]. Target audience: [describe]. The guidelin…

💡 Brand guidelines are only as good as their adoption. Keep them concise enough to actually be used — …

👁 8 views Open prompt →

business startups Intermediate

Business Plan Executive Summary for Investor Pitch

Write a compelling executive summary for a business plan for my company [company name], which is a [business type] in the [industry] space. Key details: Problem we solve: [problem]. Our solution: [solution]. Target marke…

💡 Investors read executive summaries in 2–3 minutes. Lead with the market problem, not your product. "…

👁 8 views Open prompt →

business strategy Beginner

SWOT Analysis Framework for Strategic Planning

Conduct a detailed SWOT analysis for [company name / product / project] to support strategic planning. Company context: [brief description, industry, stage]. For each quadrant, provide 5–7 specific, evidence-based points…

💡 A SWOT is only useful when it's specific. Avoid generic entries like "strong team" — instead say "fo…

👁 8 views Open prompt →

coding api-design Advanced

REST API Design for a SaaS Product with Auth

Design a RESTful API for a [SaaS product type, e.g., project management app] with the following requirements: Entities: [list entities, e.g., Users, Projects, Tasks, Comments]. Provide: (1) Complete endpoint structure (m…

💡 Use plural nouns for resource names (/users, not /user). Return 201 for creation, 204 for deletion. …

👁 8 views Open prompt →

marketing personal-branding Beginner

Social Media Bio Optimization for Personal Brand

Optimize my social media bios across platforms to build a strong personal brand. My profile: Name: [name]. Profession: [title/role]. Niche: [specific area of expertise]. Target audience: [who you want to attract]. Unique…

💡 Your bio is a landing page — it must immediately answer "why should I follow you?" Include a specifi…

👁 8 views Open prompt →

finance business-finance Intermediate

Cash Flow Forecast for Small Business (12-Month)

Create a 12-month cash flow forecast template for a [business type] with the following profile: Current monthly revenue: [$X], Revenue growth assumption: [%/month], Key revenue streams: [list]. Fixed monthly costs: [list…

💡 Cash flow ≠ profit. A profitable business can go bankrupt from cash flow timing issues. Model the pe…

👁 8 views Open prompt →

design ux Intermediate

UX Audit Checklist for Web Application

Conduct a UX audit framework for a web application, specifically designed for [type of app, e.g., project management tool, e-commerce checkout, SaaS onboarding]. The audit should cover: (1) First Impressions (above the f…

💡 Do your first UX audit as a user — close the documentation and try to complete a real task cold. The…

👁 8 views Open prompt →

marketing Conversion Optimization advanced

Conversion Rate Optimization Audit Landing Page

Conduct a conversion rate optimization (CRO) audit framework for a landing page. Page goal: [describe — e.g., free trial sign-up, demo request, ebook download]. Current conversion rate: [X%]. Traffic source: [organic sea…

💡 Start A/B testing the headline and CTA button — they have the highest leverage on conversion rate. R…

👁 8 views Open prompt →

excel Formulas & Functions advanced

Excel LAMBDA Custom Functions for Business Calculations

Create Excel LAMBDA functions for: 1) CAGR given start value, end value, and years, 2) Weighted Average with variable ranges, 3) Business days between two dates excluding weekends, 4) Tiered commission calculation based …

💡 LAMBDA functions require Microsoft 365 or Excel 2021+. Save them via Formulas > Name Manager. You ca…

👁 8 views Open prompt →