🔧 AI Prompt Library

excel Data Management Intermediate

Excel Data Validation and Dropdown Lists

Teach me how to create advanced data validation and dependent dropdown lists in Excel. My use case: [describe your spreadsheet — e.g., "Product order form where category selection determines available products"] **Crea…

💡 Use Excel Tables (Ctrl+T) for dynamic ranges that auto-expand. Keep your validation source data on a…

👁 7 views Open prompt →

📋 Copy prompt

excel Power Query Advanced

Power Query: Merge and Transform Multiple CSV Files

I have a folder containing monthly CSV files (January.csv, February.csv, etc.) with identical column structures: - Date, Product, Region, Units Sold, Revenue, Cost Help me set up a Power Query in Excel that: 1. Automati…

💡 Make sure all CSV files have consistent column headers. If some files use different delimiters (comm…

👁 7 views Open prompt →

📋 Copy prompt

email Business Negotiation Advanced

Vendor Price Negotiation Email Series

Write a 3-email sequence for negotiating better pricing with an existing vendor/supplier: Context: - Vendor: [name] - Product/Service: [what you're buying] - Current price: [amount] - Target price: [desired amount] - Re…

💡 Always negotiate via email to create a paper trail. Research market rates before starting. Have a BA…

👁 7 views Open prompt →

📋 Copy prompt

business Strategy Advanced

Market Entry Strategy for New Geographic Region

Develop a market entry strategy for expanding into a new geographic region: - Company: [name and what you sell] - Current markets: [where you operate now] - Target market: [new country/region] - Budget for expansion: [a…

💡 Visit the target market before committing. Talk to at least 10 potential customers. Hire a local adv…

👁 7 views Open prompt →

📋 Copy prompt

excel Scheduling & Planning Advanced

Dynamic Employee Shift Schedule with Drop-downs and Conflict Detection

Act as an Excel expert. Create a weekly employee shift schedule spreadsheet for a team of 10 people. Requirements: (1) Rows = employees, Columns = Mon-Sun with shift options via data validation dropdowns: Morning (6AM-2P…

💡 Add a second week tab and link the preference sheet to both for monthly scheduling.

👁 7 views Open prompt →

📋 Copy prompt

email Professional Networking Beginner

Networking Follow-Up Email After a Conference or Event

Write 3 variations of a networking follow-up email to send within 48 hours after meeting someone at a professional conference or industry event. For each variation, include: (1) A specific reference to something you disc…

💡 Attach or link to the resource you promised in the conversation. Personalize the [placeholders] with…

👁 7 views Open prompt →

📋 Copy prompt

data Dashboards & Visualization Intermediate

Google Sheets Dashboard with Automated Data Import

Act as a Google Sheets expert. Create a complete marketing dashboard in Google Sheets that automatically pulls and visualizes data. Include: (1) **IMPORTDATA/IMPORTXML formulas** to pull data from a CSV URL or public API…

💡 IMPORTDATA refreshes every hour automatically. For faster updates, use the Apps Script time trigger …

👁 7 views Open prompt →

📋 Copy prompt

education Teaching Strategies Intermediate

Socratic Discussion Questions for Any Reading or Topic

Act as a master teacher skilled in Socratic method. Generate a complete Socratic seminar discussion guide for [topic or reading]. Create: (1) **Opening Questions** (3 questions): Broad, interpretive questions that have n…

💡 Arrange desks in a circle or fishbowl format. Give students 10 minutes to annotate the text with the…

👁 7 views Open prompt →

📋 Copy prompt

hr recruitment Beginner

ChatGPT prompt for writing a structured job description that attracts qualified candidates

Act as an HR recruiter who writes clear, credible job descriptions. Create a job description for this role: - Job title: [title] - Company type: [startup / agency / SME / enterprise] - Industry: [industry] - Employment …

💡 If the hiring manager has unrealistic expectations, paste them anyway. ChatGPT can help you trim the…

👁 7 views Open prompt →

📋 Copy prompt

productivity meeting management Beginner

ChatGPT prompt for extracting action items from meeting notes with owners and deadlines

Act as a chief of staff helping me clean up meeting notes. I will paste rough meeting notes, transcript excerpts, or bullet points. Turn them into a clean action list. Please produce: 1. A short summary of the meeting …

💡 This works especially well on messy internal meeting notes. Paste them raw instead of cleaning them …

👁 7 views Open prompt →

📋 Copy prompt

excel financial forecasting Advanced

ChatGPT prompt for Excel cash flow forecast from messy exports

You are an Excel analyst helping me build a 13-week cash flow forecast from messy exported transaction data. I will paste sample columns and 10-20 representative rows. Your job is to: 1) identify the likely date, amount,…

💡 Paste a few real rows with column names. Mention your currency, whether expenses are negative or pos…

👁 7 views Open prompt →

📋 Copy prompt

writing executive communication Beginner

ChatGPT prompt for turning meeting notes into executive brief

Act as an executive communications writer. I will paste messy meeting notes from a strategy or project meeting. Turn them into a one-page executive brief for leadership. The brief should include: objective, what was deci…

💡 Include attendee roles if possible. Mention whether the audience is founders, department heads, or c…

👁 7 views Open prompt →

📋 Copy prompt

customer-service account access Advanced

ChatGPT prompt for support macro set for SaaS account access issues

You are a customer support operations lead. Build a macro set for SaaS account access issues. Create templates for password reset not received, MFA device lost, locked account after failed attempts, invited user cannot j…

💡 Mention your actual security policy and what support agents are allowed to verify or change.

👁 7 views Open prompt →

📋 Copy prompt

excel sales operations Advanced

ChatGPT prompt for Excel sales commission tracker with tiered rates and clawbacks

Act as a sales operations analyst who is great at Excel. I need a commission tracker for sales reps that handles tiered payout rates, quota attainment, and clawbacks for refunded or canceled deals. My context: - Number …

💡 Include one or two sample deals with closed date, contract value, plan type, and refund or churn rul…

👁 7 views Open prompt →

📋 Copy prompt

email internal communication Intermediate

ChatGPT prompt for internal handoff email from sales to onboarding team

Act as a revenue operations manager. I need an internal handoff email from sales to onboarding or implementation so the customer experience stays smooth after the deal closes. Use this information: - Customer/company: […

💡 Include what was promised in the sale, the customer goal, deadlines, and any risk factors. The more …

👁 7 views Open prompt →

📋 Copy prompt

coding technical documentation Intermediate

ChatGPT prompt for documenting a legacy API endpoint before refactoring

Act as a senior software engineer doing archaeology on legacy code. I need to document an existing API endpoint before refactoring it so the team understands current behavior and hidden dependencies. Here is what I can …

💡 Paste the route, handler code, sample requests, sample responses, and any weird edge cases you alrea…

👁 7 views Open prompt →

📋 Copy prompt

data conversion analysis Advanced

ChatGPT prompt for diagnosing a sudden drop in conversion rate from mixed-source metrics

Act as a data analyst investigating a sudden conversion-rate drop. I need a structured diagnosis plan when metrics come from multiple sources and the cause is not obvious. Context: - Metric that dropped: [signup rate, c…

💡 Provide the date range, affected funnel stage, traffic sources, release notes, and any analytics cha…

👁 7 views Open prompt →

📋 Copy prompt

data customer analytics Intermediate

ChatGPT prompt for churn reason taxonomy from open-text survey responses

Act as a customer insights analyst. I need to turn messy open-text churn or exit survey responses into a useful churn-reason taxonomy that the team can track over time. Input I can give you: - Product or service: [detai…

💡 Paste 20-50 raw responses if you have them. Mention whether you need a lightweight coding system or …

👁 7 views Open prompt →

📋 Copy prompt

creative visual direction Advanced

ChatGPT prompt for art direction brief for AI-generated website hero images

Act as an art director preparing a brief for AI-generated website hero images. I need a clear creative direction that a designer or prompt writer can use without guessing. Context: - Website or landing page purpose: [de…

💡 Mention the page purpose, brand colors, audience, image dimensions, and visual references you like o…

👁 7 views Open prompt →

📋 Copy prompt

customer-service retention Intermediate

ChatGPT prompt for de-escalation reply to a cancellation request with save attempt

Act as a customer retention specialist. I need a calm, respectful response to a customer who wants to cancel, with a save attempt that does not sound pushy or manipulative. Use this context: - Customer issue or complain…

💡 Include the customer complaint, account history, what options you can offer, and any policies you mu…

👁 7 views Open prompt →

📋 Copy prompt