### Interactive Tutorial Simulator — Microsoft Excel **Task**: Create a dynamic chart that automatically updates when new data is added to a table **Audience**: Small business owners who track sales in Excel (not data experts) --- **Step 1: Likely Mistakes (to weave into Act 1)** 1. Building the chart from a static cell range (e.g., `A2:C13`) instead of an Excel Table, so new rows aren't included. 2. Adding new rows below the data or leaving a blank row, so Excel doesn't recognize them as part of the chart's source. 3. Manually dragging the chart range or repeatedly using Chart Design → Select Data after every update. 4. Typing currency symbols directly into cells (e.g., "$3400") so the Revenue column becomes text and the chart misbehaves. 5. Using mixed date formats or text dates, causing the Date axis to look wrong or not sort properly. --- **Step 2: Simulated User Persona** Meet Jordan, who runs a local bakery and updates a weekly "Sales" spreadsheet. Jordan wants a simple chart on a dashboard that grows as new weeks are added—without redoing anything. --- ### **Act 1 — The Struggle (The "Why You're Here")** **0:00 — Cold Open (screen recording of Excel)** * **On-screen:** A worksheet named Sales_Data with columns: Date | Product | Revenue (about 12 rows). * **Action:** Jordan drags to select `A1:C13`, then clicks Insert → Column → Clustered Column. * **Jordan (VO, slightly rushed):** "Okay, quick sales chart for the weekly report. Select the range... insert chart... done!" **0:12 — First Update Attempt** * **Action:** Jordan scrolls down, types a new week's row in `A14:C14`. * **On-screen:** The chart doesn't include the new bar. * **Jordan (VO, confused):** "Huh? Why isn't the new week showing up?" **0:18 — Manual Fix Cycle** * **Action:** Jordan clicks the chart → Chart Design → Select Data → edits the range to `A1:C14`. * **On-screen text (subtle caption):** "Manual range updates = time sink" * **Jordan (VO, resigned):** "Guess I'll just extend the range... again." **0:28 — The "Tidy" Blank Row** * **Action:** Jordan adds a blank row after the data "to separate this week from next week." * **On-screen:** Next week's data is typed below the blank row. The chart still won't auto-include it. * **Jordan (VO, frustrated):** "Why is Excel so picky? I just want it to update by itself!" **0:38 — Formatting Trap** * **Action:** Jordan types "$3400" into Revenue for the new week. * **On-screen:** That value aligns left (text), chart ignores/skips or behaves oddly. * **Jordan (VO, sighs):** "Now the numbers look weird. Do I have to rebuild the whole thing every time?" **0:48 — Cliffhanger** * **On-screen:** Jordan stares at the messy chart. * **On-screen text (big, friendly):** "There's a faster, smarter way." --- ### **Act 2 — The Solution (The "How to Fix It")** **Tone:** Calm, clear, encouraging. **Goal:** A chart that auto-updates whenever Jordan adds new rows—no manual range edits. **Step 1 — Clean the Data (10 seconds)** * **Instructor (VO):** "First, let's make the data easy for Excel to understand." * **On-screen actions:** 1. Remove any blank rows inside the data block. 2. Select the Date column → Home → Number → Short Date. 3. Select the Revenue column → Home → Number → Currency. If you typed "$3400" as text, re-type 3400 and let formatting add the symbol. * **On-screen text (lower-third):** "TIP: Don't type the $—use Currency formatting." * **Why this fixes Act 1 mistakes:** Ensures dates and amounts are real numbers, so the chart reads them correctly. **Step 2 — Convert to an Excel Table (20 seconds)** * **Instructor (VO):** "The simplest way to get auto-expanding charts is to use an Excel Table." * **On-screen actions:** 1. Click any cell in the data. 2. Press Ctrl+T (Windows) or ⌘+T (Mac) → check 'My table has headers' → OK. 3. Go to Table Design (or Table Tools) → Table Name → type: SalesTbl. * **On-screen text:** "Create a Table → Name it clearly (e.g., SalesTbl)." * **Why this fixes Act 1 mistakes:** Charts built from Tables automatically expand to include new rows—no more manual range edits. **Step 3 — Build the Chart from the Table (25 seconds)** * **Instructor (VO):** "Now, we'll create the chart using the table so it auto-updates." * **On-screen actions:** 1. Click any cell in SalesTbl. 2. Insert → Column → Clustered Column (or choose Line if you prefer trends). 3. The chart appears. Click it → Chart Design → Select Data to confirm it's using table columns (you'll see references like `SalesTbl[Date]` and `SalesTbl[Revenue]`). * **On-screen text:** "Look for structured references: SalesTbl[Date], SalesTbl[Revenue]" * **Callout box:** "Tempted to use Chart Design → Select Data every week like Jordan did? With a Table, you won't need to." **Step 4 — Test the Auto-Update (15 seconds)** * **Instructor (VO):** "Let's prove it works." * **On-screen actions:** 1. Click the last cell in the table and press Tab to add a new row inside the table. 2. Type a new Date, Product, and Revenue. 3. Watch the chart extend automatically. * **On-screen text (animated):** "Auto-update ✅ — No manual range edits" * **Why this fixes Act 1 mistakes:** Adding rows inside the table (not below a blank row) keeps the chart in sync. **Step 5 — Optional: Make It Interactive with a Slicer (20 seconds)** * **Instructor (VO):** "If you track multiple products, make the chart interactive with a Slicer." * **On-screen actions:** 1. Click inside SalesTbl → Table Design → Insert Slicer → check Product → OK. 2. Click items in the Slicer to filter the table—the chart updates instantly. * **On-screen text:** "Slicer = Click-to-filter dashboard" * **Note:** Slicers work directly with Tables (and PivotTables), giving you a quick mini-dashboard without formulas. **Step 6 — Polishing Touches (15 seconds)** * **Instructor (VO):** "Finally, let's tidy the chart so it's presentation-ready." * **On-screen actions:** 1. Chart Elements (+) → add Axis Titles and Data Labels (optional). 2. Chart Design → Quick Layout (pick a clean layout). 3. Chart Design → Change Colors (choose a brand-friendly palette). 4. Right-click Date Axis → Format Axis → ensure the Units and Number format look right. * **On-screen text:** "Keep it clean, readable, on-brand." **Recap (on-screen checklist)** * Don't build charts from static ranges. * Do convert your data to a Table (`Ctrl+T` / `⌘+T`) and name it. * Add new rows inside the table (no blank separators). * Use proper formats for dates and currency. * Optional: Add a Slicer for instant product filtering. * **Instructor (VO, closing):** "With a named Table and a chart built from it, your weekly updates take seconds—not hours. Add new sales, and the chart keeps up automatically." **On-Screen Text & Graphics (quick list for editor)** * **Lower-third tips:** "TIP: Use Ctrl+T / ⌘+T to create a Table", "Add new rows inside the Table", "Use Currency and Short Date formats" * **Callouts:** "Structured references = auto-expanding chart", "No more Select Data every week" * **End card:** "Make it a Table → Name it → Chart it → Done." **Audio/Visual Notes** * **SFX:** Soft "click" sounds for key actions; subtle "whoosh" when the chart auto-updates. * **B-Roll:** Quick cutaways of bakery counter / sales receipts to ground the context. * **Cursor highlights:** Brief yellow halo when clicking key buttons. * **Zooms:** 120% zoom on Ctrl+T dialog, Table Name box, and Select Data window. **Keyboard Shortcuts (show briefly on screen)** * **Create Table:** Ctrl+T (Windows) / ⌘+T (Mac) * **Add new row in Table:** Press Tab in the last row * **Format Cells:** Ctrl+1 (Windows) / ⌘+1 (Mac) You're set! This script gives you the empathy-building struggle, the exact fixes, and crisp on-screen directions to record a polished, highly useful tutorial.