About Prompt
- Prompt Type – Dynamic
- Prompt Platform – Google Veo
- Niche – Education
- Language – English
- Category – Video
- Prompt Title – Veo Prompt for Producing Excel Advanced Functions Tutorial Shorts
Prompt Details
—
### **Veo Dynamic Prompt: “Excel Pro Tips” Tutorial Shorts Series**
**Prompt Type:** Dynamic (Template Structure)
**AI Model:** Google Veo
**Niche:** Education (Tech/Productivity)
**Purpose:** Video (YouTube Shorts, Instagram Reels, TikTok)
**Language:** English
—
### **[PROMPT TEMPLATE START]**
**1. Core Objective:**
Generate a 45-60 second, vertically-oriented (9:16 aspect ratio) video tutorial for the Microsoft Excel function: **`[FUNCTION_NAME]`**. The video should be engaging, easy to follow, and visually clean, targeting an audience of intermediate Excel users looking to improve their skills.
**2. Dynamic Variables (To be filled for each new video):**
* **`[FUNCTION_NAME]`**: The name of the Excel function being taught (e.g., “XLOOKUP”, “SUMIFS”, “INDEX & MATCH”, “FILTER”).
* **`[PROBLEM_STATEMENT]`**: A relatable problem that this function solves, phrased as a question for the hook (e.g., “Tired of VLOOKUP’s limitations?”, “Need to sum data with multiple conditions?”, “How do you dynamically filter a large dataset?”).
* **`[DATASET_THEME]`**: A simple, clean theme for the example spreadsheet to make it visually interesting (e.g., “Fictional Coffee Shop Sales Data”, “Quarterly Marketing Campaign KPIs”, “Student Grade Roster”).
* **`[FORMULA_SYNTAX_BREAKDOWN]`**: A simplified, step-by-step text description of the formula’s arguments. (e.g., for XLOOKUP: “1. What to find, 2. Where to look, 3. What to return”).
* **`[EXAMPLE_FORMULA]`**: The exact formula as it would be typed in the video (e.g., `=XLOOKUP(G2, A2:A10, C2:C10)`).
* **`[KEY_BENEFIT]`**: A concise concluding statement about the function’s primary advantage (e.g., “It’s faster, more flexible, and can look left!”, “The ultimate tool for conditional sums.”, “Create interactive reports instantly.”).
**3. Scene-by-Scene Sequence:**
* **(0-3 seconds) The Hook:**
* **Visual:** Extreme close-up on a frustrating element in an Excel sheet related to the problem. For example, a cell showing a `#N/A!` error, or a user manually highlighting and adding numbers. The spreadsheet should be aesthetically pleasing but clearly show the problem.
* **On-Screen Text:** Animated, bold text appears: **`[PROBLEM_STATEMENT]`**.
* **(4-8 seconds) The Solution Reveal:**
* **Visual:** Smooth zoom-out from the problem cell. A clean, modern graphic overlay with the Excel logo and the function name appears.
* **On-Screen Text:** **”Meet the `[FUNCTION_NAME]` function!”**. The text should have a subtle, satisfying animation, like a gentle fade-in and scale-up.
* **(9-35 seconds) The Demonstration (Core Tutorial):**
* **Visual:** A high-fidelity screen recording of the Excel interface. The `[DATASET_THEME]` is clearly visible. The cursor moves with deliberate, easy-to-follow pacing.
* **Action 1:** The cursor clicks an empty cell. The user begins typing **`[EXAMPLE_FORMULA]`**.
* **Action 2:** As each argument of the formula is typed, use a **callout graphic** or a **colored highlight** to visually link it to the corresponding data array in the spreadsheet. The **`[FORMULA_SYNTAX_BREAKDOWN]`** points should appear on-screen one by one as the corresponding part of the formula is entered. For example, as the `lookup_array` is selected, the text “Where to look” is highlighted on screen.
* **Action 3:** The user presses Enter.
* **(36-40 seconds) The “Aha!” Moment:**
* **Visual:** The correct result instantly populates the cell. A subtle, satisfying animation occurs, like a green checkmark appearing momentarily or the cell briefly glowing. A dolly zoom-in effect focuses on the correct result, showing that the problem is solved.
* **(41-45 seconds) The Benefit & Outro:**
* **Visual:** A split-screen or picture-in-picture effect. On one side, the final spreadsheet with the working formula. On the other side, a clean graphic background.
* **On-Screen Text:** A bold, clear statement: **`[KEY_BENEFIT]`**. Followed by a Call-to-Action: **”Like & Follow for more Excel Pro Tips!”**.
**4. Overall Style Guide (Consistent Across the Series):**
* **Aesthetic:** Clean, minimalist, modern tech tutorial. Bright and accessible.
* **Color Palette:** Use a primary color palette of white, dark gray, and Microsoft Excel’s green (#1D6F42). Use one bright accent color (e.g., a vibrant blue or orange) for highlights and callouts.
* **Fonts:** Use a clean, sans-serif font like Inter or Montserrat for all on-screen text.
* **Pacing:** Brisk and energetic, with quick cuts that keep the viewer engaged. No dead air.
* **UI Elements:** All graphics, text overlays, and callouts should be flat, modern, and have a slight drop shadow for readability against the spreadsheet background.
* **Audio:** An upbeat, royalty-free lo-fi or instrumental tech track playing quietly in the background. Add subtle, satisfying sound effects for keyboard clicks and the final result appearing.
**5. Negative Prompts (What to Avoid):**
* No distracting human faces or narrators.
* No clunky 3D animations or outdated clipart.
* No corporate stock video footage.
* No overly complex or messy spreadsheets in the demonstration.
* Avoid using blurry or low-resolution screen recordings.
### **[PROMPT TEMPLATE END]**
—
### **Example Usage (Filled-out for an XLOOKUP video):**
* **`[FUNCTION_NAME]`**: “XLOOKUP”
* **`[PROBLEM_STATEMENT]`**: “Tired of VLOOKUP’s #N/A errors?”
* **`[DATASET_THEME]`**: “Fictional Coffee Shop Sales Data” (Columns: Product ID, Product Name, Price, Units Sold).
* **`[FORMULA_SYNTAX_BREAKDOWN]`**: “1. Lookup Value, 2. Lookup Array, 3. Return Array”
* **`[EXAMPLE_FORMULA]`**: `=XLOOKUP(F2, A2:A11, C2:C11)`
* **`[KEY_BENEFIT]`**: “The modern, powerful successor to VLOOKUP!”