About Prompt
- Prompt Type – Dynamic
- Prompt Platform – Google Veo
- Niche – Tutorial
- Language – English
- Category – Video
- Prompt Title – Veo Prompt for Creating Video Tutorials on Conditional Formatting in Excel
Prompt Details
**Objective:** Generate a high-definition (1080p), 16:9 aspect ratio video tutorial on using Conditional Formatting in Microsoft Excel. The video should be clean, professional, and easy to follow for a beginner to intermediate audience.
**Prompt Type:** Dynamic
**Target AI Model:** Google Veo
—
### **// Global Directives & Style Guide**
* **Aesthetic:** Clean, minimalist corporate tutorial. Bright, even lighting.
* **Pacing:** Deliberate and smooth. Actions should be clear, with slight pauses after key steps to allow for viewer comprehension.
* **On-Screen Elements:**
* **Cursor:** A modern, slightly oversized cursor with a subtle yellow highlight or a gentle ripple effect on click to draw attention.
* **UI (User Interface):** A modern version of Microsoft Excel (Office 365) with a standard, clean interface. All text within the UI must be sharp and legible.
* **Text Overlays:** Use a clean, sans-serif font (like Arial or Roboto) for titles and annotations. Text should animate in smoothly (e.g., a gentle fade or slide-in).
* **Zooms & Pans:** Use smooth, digital zooms to focus on specific menus, dialog boxes, or cells being modified. Pan slowly across larger datasets.
* **Audio Direction (for pacing and mood):** Imagine a clear, friendly voiceover explaining the steps, accompanied by subtle, upbeat, royalty-free background music and soft, satisfying UI click sounds.
* **Negative Prompts:**
* `no human hands or fingers`
* `no cluttered desktop backgrounds`
* `no screen glare or reflections`
* `no blurry or pixelated text`
* `no jarring cuts or shaky camera movements`
* `no outdated Excel versions`
—
### **// Scene Breakdown & Sequence**
**Scene 1: Title & Hook (Duration: 5 seconds)**
* **Shot:** A wide shot of a plain, data-heavy Excel spreadsheet filled with sales figures `[Dataset: Q4 Regional Sales]`. The data looks dense and difficult to interpret.
* **Action:** A smooth, sweeping “wipe” transition reveals the *same* spreadsheet, but now it’s beautifully organized with Conditional Formatting. High-value sales are highlighted in green, low values in red, and data bars show performance at a glance.
* **Text Overlay:** Title animates onto the center of the screen: “**Master Excel Conditional Formatting**” with a subtitle: “**From Data to Decisions in Seconds**”.
**Scene 2: Basic Rule – Highlight Cells (Duration: 15 seconds)**
* **Shot:** A screen-recording style view, focusing on a column of sales figures. The shot is framed to show the relevant data and the ‘Home’ tab on the Excel ribbon.
* **Action:**
1. The glowing cursor smoothly selects the entire sales column `[Column: “Total Sales”]`.
2. The cursor moves to the ‘Home’ tab and clicks on the “Conditional Formatting” button. A dropdown menu appears.
3. The cursor navigates to “Highlight Cells Rules” > “Greater Than…”.
4. A dialog box `[Dialog Box: Greater Than]` pops up. The camera zooms in slightly on this box.
5. The cursor clicks into the text field, and the number `[Value: 50000]` is typed.
6. The format is set to `[Format: Green Fill with Dark Green Text]`.
7. The cursor clicks “OK”.
* **Visual Effect:** Instantly, all cells in the selected column with a value over 50,000 are highlighted in vibrant green. The effect is fast and satisfying.
**Scene 3: Intermediate Rule – Data Bars (Duration: 15 seconds)**
* **Shot:** The view shifts to a new dataset on a different sheet, showing project completion percentages `[Dataset: Project Task Progress]`.
* **Action:**
1. The cursor selects the column of percentages `[Column: “Progress %”]`.
2. The cursor clicks “Conditional Formatting” > “Data Bars”.
3. A palette of color options appears. The cursor hovers over a few, showing a live preview of the data bars appearing in the cells.
4. The cursor clicks on “Gradient Fill” with a blue color `[Format: Blue Gradient Data Bar]`.
* **Visual Effect:** Each cell in the column instantly fills with a horizontal bar proportional to its percentage value, creating an intuitive, at-a-glance progress chart. Pan slowly down the column to show the effect.
**Scene 4: Advanced Rule – Icon Sets (Duration: 15 seconds)**
* **Shot:** The view moves to a third dataset, a simple table of Key Performance Indicators (KPIs) showing performance against a target `[Dataset: Monthly KPI Status]`. The column shows positive, neutral, and negative variance numbers.
* **Action:**
1. The cursor selects the variance column `[Column: “Variance”]`.
2. The cursor clicks “Conditional Formatting” > “Icon Sets”.
3. The cursor hovers over the 3 Traffic Lights (Unrimmed) option `[Format: 3 Traffic Lights Icon Set]`, and a live preview appears.
4. The cursor clicks to apply the rule.
* **Visual Effect:** A green circle appears next to positive numbers, a yellow circle next to numbers close to zero, and a red circle next to negative numbers, providing instant visual status cues. A close-up shot highlights one of each icon type.
**Scene 5: Outro & Summary (Duration: 8 seconds)**
* **Shot:** A dynamic split-screen or a quick montage showing the three formatted spreadsheets from the previous scenes.
* **Action:** The final formatted sheets are shown side-by-side, demonstrating the versatility of the tool.
* **Text Overlay:** A final message appears: “**Visualize Your Data. Make Smarter Decisions. Faster.**” followed by a simple logo or channel name placeholder. The video fades to black.
**[PROMPT END]**