Prompt Library
Prompt Library
Your curated collection of high-impact AI instructions.
Excel
The Excel Agent Instruction
Turn ChatGPT into an autonomous data analyst that cleans, analyzes, and visualizes data.
Act as a Senior Data Analyst. I am going to provide you with a dataset.
Your goal is to:
1. CLEAN: Identify and fix any inconsistencies, missing values, or formatting errors.
2. ANALYZE: Identify the top 3 trends and any significant outliers.
3. VISUALIZE: Suggest the best chart type for each trend.
Do not ask for clarification. If you are unsure, make a reasonable assumption and state it.
Here is the data: [PASTE DATA HERE]
Data Analysis
Automation
Advanced
Strategy
Executive Briefing Generator
Synthesize complex documents into a 1-page executive summary for leadership.
Act as a Chief of Staff. I am uploading a [Whitepaper/Report/10-K].
Draft a 1-page Executive Briefing for the CEO.
Structure:
1. BOTTOM LINE UP FRONT: The single most important takeaway in 1 sentence.
2. STRATEGIC IMPLICATIONS: 3 bullet points on how this impacts our business.
3. CRITICAL RISKS: What could go wrong?
4. RECOMMENDED ACTION: What should we do next?
Tone: Professional, concise, direct. No fluff.
Leadership
Synthesis
NotebookLM
Communication
PACE Delegation Framework
The standard template for delegating any complex task to AI.
PERSONA: Act as a [Role, e.g., Senior Marketing Manager].
ACTION: Create a [Output, e.g., Q3 Campaign Plan].
CONTEXT: The audience is [Target Audience]. The goal is [Specific Goal]. Constraints are [Budget/Time].
EXPECTATION: The output should be [Format, e.g., a table with columns for Channel, Budget, KPI].
Framework
Basics
Day 1