╔══════════════════════════════════════════════════════════════════╗
║  FROM EXCEL TO AI TOOLS — Master Prompt Library                ║
║  From Spreadsheets to Code Series — Book 6                     ║
║  Waskey Press | www.waskeypress.com                            ║
╚══════════════════════════════════════════════════════════════════╝

HOW TO USE THIS LIBRARY
────────────────────────
1. Open your AI tool: Claude (claude.ai), ChatGPT (chat.openai.com),
   or Copilot (copilot.microsoft.com)
2. Copy a prompt from below
3. Replace [BRACKETS] with your actual data or context
4. Paste into the AI tool and press Enter
5. Save the prompts that work well — customise them for your datasets

QUICK REFERENCE — PROMPT PATTERNS
───────────────────────────────────
DATA ANALYSIS
  "Analyse this [dataset excerpt]. Identify [specific patterns/issues]."
  "Given this data: [paste]. Calculate [metric]. Show your working."

FORMULA GENERATION
  "I have Excel columns: [A=..., B=..., C=...]. Write a formula for column D that [logic]."
  "Convert this Excel formula to plain English: [=formula]"

WRITING FROM DATA
  "Write a [document type] based on this data: [numbers]. Tone: [tone]. Max [N] words."
  "Convert this [paragraph/table] into [4 bullet points / slide / email]."

VBA / CODE GENERATION
  "Write a VBA macro that [action]. It should [constraint 1], [constraint 2]."
  "Write Python/pandas code that reads [file], [transforms], and saves [output]."

CHAIN STRUCTURE (for complex tasks)
  Step 1: "Extract [KPIs] from [data]. Format as [JSON/list/table]."
  Step 2: "Using [Step 1 output], write [commentary/email/report]."
  Step 3: "Convert [Step 2 output] to [PowerPoint bullets/shorter version]."

SAFE DATA PRACTICES
───────────────────
⚠ Never paste: customer names, employee salaries, personal emails,
  contract values, or any data your company classes as confidential.
✅ Safe to paste: anonymised samples, aggregate numbers, column headers,
  synthetic or test data.
  
Use sales_sample_10rows.csv (included) — it is synthetic, safe to share.

SAVE YOUR BEST PROMPTS
────────────────────────
When a prompt gets a great result:
1. Copy the prompt (not just the output)
2. Save it to your own prompt library (a text file or Notion page)
3. Note which AI tool gave the best result
4. Add the date — some prompts stop working when models update

CONTACT
────────
waskeypress.com/files | contact@waskeypress.com
