# Chapter 1 — Your First Prompts
# Copy any prompt below, paste into ChatGPT / Claude / Copilot
# Then paste a few rows from sales_sample_10rows.csv after the prompt

# ── PROMPT 1: data description ─────────────────────────────────
I have a sales dataset in Excel with 2,150 rows and these columns:
date, customer, region, product, category, quantity, unit_price, total, status, sales_rep

Here is a 10-row sample:
[PASTE sales_sample_10rows.csv here]

Describe what this dataset contains in 3 bullet points. What business
questions could it answer?

# ── PROMPT 2: quick analysis ────────────────────────────────────
Using the sales sample above, identify:
1. The highest and lowest order by total
2. Which region appears most often
3. What percentage of orders are Delivered
Show your working.

# ── PROMPT 3: Excel formula request ─────────────────────────────
I have a sales dataset in Excel. Column H = total, Column I = status.
Write an Excel formula for cell J2 that:
- Returns "HIGH VALUE" if total >= 2000 AND status = "Delivered"
- Returns "MONITOR" if status = "Cancelled"
- Returns "STANDARD" otherwise

# ── PROMPT 4: VBA request ───────────────────────────────────────
Write a VBA macro for Excel that:
- Reads column I (status) in the active sheet
- Colours each row: green for Delivered, yellow for Shipped,
  blue for Pending, red for Cancelled
- Turns ScreenUpdating off before the loop, on after
- Works on any number of rows (use End(xlUp) to find the last row)
