Write Training and Tutorial Video Scripts with AI

# VIDEO SCRIPT: "Build Your First Pivot Table in Excel"
**Runtime:** ~3 minutes | **Audience:** New Marketing Analysts | **Tone:** Friendly & Encouraging

---

## 🎬 HOOK (0:00 – 0:15)

**NARRATION:**
"Staring at a 10,000-row sales spreadsheet and wondering how you'll ever make sense of it? Good news — in the next three minutes, you'll turn that chaos into clear, filterable insights using one of Excel's most powerful tools: the pivot table."

**ON-SCREEN TEXT:**
> From Messy Data → To Marketing Insights
> In Under 3 Minutes

**VISUAL/B-ROLL:**
[Fast zoom across a cluttered sales spreadsheet. Quick cut to a clean, color-coded pivot table appearing with a satisfying "ding." Upbeat background music begins.]

---

## 👋 INTRO (0:15 – 0:30)

**NARRATION:**
"Hi there, and welcome! I'm so glad you're here. As a new marketing analyst, pivot tables will quickly become your best friend for summarizing campaigns, spotting top products, and reporting to stakeholders. Let's build one together — step by step."

**ON-SCREEN TEXT:**
> Your New Best Friend: The Pivot Table

**VISUAL/B-ROLL:**
[Presenter on camera (or animated avatar) waving. Icon animations of a megaphone, a chart, and a lightbulb appear next to them.]

---

## 🎯 LEARNING OBJECTIVES (0:30 – 0:40)

**NARRATION:**
"By the end of this video, you'll be able to do three things: build a pivot table from a sales spreadsheet, filter it for specific insights, and format it so it actually looks great."

**ON-SCREEN TEXT:**
> You'll Learn To:
> 1. Build a pivot table
> 2. Filter your data
> 3. Format for clarity

**VISUAL/B-ROLL:**
[Three checklist items slide in one at a time with a soft tick sound.]

---

## 📘 MAIN CONTENT

### MODULE 1: Build Your Pivot Table (0:40 – 1:25)

**NARRATION:**
"Let's start with a sample sales sheet — columns for Date, Region, Product, Campaign, and Revenue. First, click anywhere inside your data. Then head to the **Insert** tab and click **PivotTable**. Excel will automatically detect your range — nice, right? Choose **New Worksheet** and hit **OK**.

Now, on the right, you'll see the PivotTable Fields pane. Drag **Product** into **Rows**, drag **Region** into **Columns**, and drag **Revenue** into **Values**. Boom — instant summary of revenue by product and region."

**ON-SCREEN TEXT:**
> Insert → PivotTable → New Worksheet
> Rows: Product | Columns: Region | Values: Revenue

**VISUAL/B-ROLL:**
[Screen recording of Excel. Cursor highlights each click. Red circle around the Insert tab. Drag-and-drop animations with arrows showing fields moving into Rows, Columns, and Values.]

---

### MODULE 2: Filter for Insights (1:25 – 2:10)

**NARRATION:**
"Now let's zoom in on what matters. Drag the **Campaign** field into the **Filters** area at the top of the Fields pane. See that new dropdown above your table? Click it, pick a campaign — say, 'Spring Launch' — and your entire pivot table updates instantly.

Want to narrow things further? Click any row or column header's dropdown arrow to filter specific products or regions. This is how you answer questions like, 'Which region won our Spring Launch?' in seconds."

**ON-SCREEN TEXT:**
> Filters: Campaign
> 💡 Tip: Filter to answer one question at a time

**VISUAL/B-ROLL:**
[Screen recording showing Campaign dragged to Filters. Dropdown opens, "Spring Launch" selected. Pivot table visibly updates. Highlight box around the dropdown arrows on row/column headers.]

---

### MODULE 3: Format It Like a Pro (2:10 – 2:40)

**NARRATION:**
"Last step — make it look polished. Right-click any revenue number, choose **Number Format**, and select **Currency**. Next, click anywhere in your pivot table, go to the **Design** tab, and pick a style you like. Finally, rename your headers by clicking the cell and typing something friendly, like 'Total Revenue.' Clean, clear, stakeholder-ready."

**ON-SCREEN TEXT:**
> Format → Currency
> Design Tab → Pick a Style
> Rename Headers for Clarity

**VISUAL/B-ROLL:**
[Right-click menu appears, Currency selected, numbers reformat to $. Design tab styles gallery scrolls through. Header text changes from "Sum of Revenue" to "Total Revenue."]

---

## 🔁 RECAP (2:40 – 2:50)

**NARRATION:**
"Let's quickly recap: you inserted a pivot table, dragged fields into Rows, Columns, and Values, added a filter, and formatted it to shine. That's it — you just unlocked a core analyst skill."

**ON-SCREEN TEXT:**
> ✅ Build ✅ Filter ✅ Format

**VISUAL/B-ROLL:**
[Three checkmarks pop in with a cheerful chime. Finished pivot table displayed in background.]

---

## 🚀 CALL TO ACTION (2:50 – 3:00)

**NARRATION:**
"Your turn! Download the practice sales sheet in the description and build a pivot table of your own. When you're ready for more, check out our next video on pivot charts. You've got this — happy analyzing

# PIVOT TABLES IN EXCEL: A Quick-Start Guide for Marketing Analysts

**VIDEO LENGTH:** 3 minutes | **AUDIENCE:** New Marketing Analysts with Basic Excel Skills

---

## [HOOK - 0:00-0:15]

**ON-SCREEN TEXT:**
"Analyzing 1,000 rows of sales data?"

**VISUAL/B-ROLL:**
[Rapid montage: screen showing cluttered spreadsheet with hundreds of rows, frustrated analyst rubbing temples, clock ticking]

**NARRATION:**
"We've all been there—drowning in spreadsheet data, struggling to spot trends. What if I told you there's a tool that can organize all that chaos into clear insights in just 60 seconds?"

**ON-SCREEN TEXT:**
"Meet: Pivot Tables"

**VISUAL/B-ROLL:**
[Transition effect: data transforms into organized pivot table, analyst smiles with relief]

---

## [INTRO - 0:15-0:30]

**ON-SCREEN TEXT:**
"How to Create a Pivot Table in Excel"

**VISUAL/B-ROLL:**
[Clean Excel workspace opening, light background music fades in]

**NARRATION:**
"Hi! I'm here to walk you through pivot tables—one of the most powerful tools you'll use as a marketing analyst. By the end of this video, you'll be able to build, filter, and format a pivot table like a pro. And trust me, your reports are about to look amazing."

---

## [LEARNING OBJECTIVES - 0:30-0:45]

**ON-SCREEN TEXT:**
"What You'll Learn Today:
✓ How to build a pivot table from raw sales data
✓ How to arrange and organize your data fields
✓ How to filter for specific insights
✓ How to format your table professionally"

**VISUAL/B-ROLL:**
[Checkmarks appear one by one with subtle animations]

**NARRATION:**
"Here's what we're covering: building a pivot table from scratch, arranging your data the right way, filtering to find what matters, and making it look professional. Ready? Let's go."

---

## [MODULE 1: PREPARING YOUR DATA - 0:45-1:15]

**ON-SCREEN TEXT:**
"STEP 1: Select Your Data"

**VISUAL/B-ROLL:**
[Screen recording: Excel spreadsheet with sample sales data (columns: Date, Region, Product, Sales Amount, Quantity). Cursor clicks on cell A1]

**NARRATION:**
"First things first—you need clean, organized data. This means headers in the first row and no blank rows or columns in between. Here's our sample: dates, regions, products, and sales amounts."

**VISUAL/B-ROLL:**
[Animation shows cursor selecting entire data range from A1 to E100, highlighting the selection in blue]

**ON-SCREEN TEXT:**
"Select: Data Range (Headers + All Rows)"

**NARRATION:**
"Click on your first cell with a header and drag to select your entire dataset, or use Ctrl+A if your data is clean. Make sure you include those headers—they're crucial."

---

## [MODULE 2: CREATING THE PIVOT TABLE - 1:15-1:50]

**ON-SCREEN TEXT:**
"STEP 2: Insert a Pivot Table"

**VISUAL/B-ROLL:**
[Screen recording: cursor navigates to top menu]

**NARRATION:**
"With your data selected, head to the 'Insert' tab at the top of your screen."

**VISUAL/B-ROLL:**
[Menu clicks: Insert → Pivot Table. Pivot Table dialog box appears]

**ON-SCREEN TEXT:**
"Insert Tab → Pivot Table"

**NARRATION:**
"Click 'Pivot Table,' and a dialog box will pop up. It's asking where your data is and where you want the table to go. The defaults are usually fine, so just click 'OK.'"

**VISUAL/B-ROLL:**
[Dialog box with options highlighted, then 'OK' button clicked. New blank pivot table interface appears]

**ON-SCREEN TEXT:**
"The Pivot Table Field List"

**VISUAL/B-ROLL:**
[Right side panel shows field list with columns: Date, Region, Product, Sales Amount, Quantity. Four drop zones below: Filters, Columns, Rows, Values]

**NARRATION:**
"Now you'll see the Pivot Table Field List on the right. Those boxes at the bottom—Filters, Columns, Rows, and Values—are where the magic happens. Think of them like organizing bins for your data."

---

## [MODULE 3: BUILDING THE STRUCTURE - 1:50-2:30]

**ON-SCREEN TEXT:**
"STEP 3: Drag Fields to Organize Data"

**VISUAL/B-ROLL:**
[Screen recording showing drag-and-drop actions]

**NARRATION:**
"Let's say you want to see sales by region and product. Drag 'Region' to the Rows box."

**VISUAL/B-ROLL:**
[Animation: Region field dragged from list to Rows box. Rows area now shows "Region"]

**NARRATION:**
"Now drag 'Product' to the Columns box."

**VISUAL/B-ROLL:**
[Animation: Product field dragged to Columns box. Columns area now shows "Product"]

**NARRATION:**
"Finally, drag 'Sales Amount' to the Values box—this is what we're actually measuring."

**VISUAL/B-ROLL:**
[Animation: Sales Amount dragged to Values box. Pivot table instantly populates with data, showing regions as rows, products as columns, sales figures filling the grid]

**ON-SCREEN TEXT:**
"Your Pivot Table is Born!"

**VISUAL/B-ROLL:**
[Clean pivot table visible with organized data, subtle celebration animation]

**NARRATION:**
"And there it is! Your raw data is now organized. You can instantly see which regions and products are performing. Beautiful, right?"

---

## [MODULE 4: FILTERING & FORMATTING - 2:30-2:55]

**ON-SCREEN TEXT:**
"STEP 4: Filter for Insights"

**VISUAL/B-ROLL:**
[Screen recording: cursor hovers over Region filter button in pivot table, dropdown arrow appears]

**NARRATION:**
"See those little dropdown arrows in your table? Click one to filter. Let's say you only want to see the North region. Click the arrow, uncheck 'All,' then check just 'North.'"

**VISUAL/B-ROLL:**
[Dropdown menu appears, checkboxes are unchecked, 'North' is checked, click OK. Table updates to show only North data]

**NARRATION:**
"Your table updates instantly. That's the power of pivot tables—explore your data without creating a dozen spreadsheets."

**ON-SCREEN TEXT:**
"STEP 5: Format for Impact"

**VISUAL/B-ROLL:**
[Screen recording: right-click on pivot table, format menu appears]

**NARRATION:**
"To make it look polished, right-click anywhere in your table and choose a design. Excel has built-in styles that add colors and structure in one click."

**VISUAL/B-ROLL:**
[Pivot Table Design tab opens, design gallery shown. Cursor clicks a professional blue theme. Table transforms with formatted colors and borders]

**NARRATION:**
"Choose a style, and boom—your analysis looks report-ready."

---

## [RECAP - 2:55-3:00]

**ON-SCREEN TEXT:**
"You Just Learned:
✓ Select clean data with headers
✓ Insert a pivot table
✓ Drag fields to Rows, Columns, and Values
✓ Filter and format like a pro"

**VISUAL/B-ROLL:**
[Montage of key steps plays quickly in sequence]

**NARRATION:**
"You've now got the core skills: prepare your data, build the structure, filter for insights, and format for impact. That's everything you need to start impressing your team with data analysis."

---

## [CTA - 3:00-3:00]

**ON-SCREEN TEXT:**
"Ready to Try It?
Open Excel. Build Your First Pivot Table.
Questions? Drop them in the comments below."

**VISUAL/B-ROLL:**
[Upbeat, encouraging music swells. Clean Excel workspace shown with a friendly checkmark animation]

**NARRATION:**
"Now it's your turn. Open Excel, grab a sales dataset, and build your first pivot table. You've got this! And if you get stuck, drop a comment below.

## HOOK

**NARRATION:**  
Need a fast way to turn a messy sales spreadsheet into clear insights? In the next three minutes, you’ll learn how to build a pivot table in Excel so you can summarize sales data, filter it, and make it presentation-ready in just a few clicks.

**ON-SCREEN TEXT:**  
Turn raw sales data into insights with Pivot Tables

**VISUAL/B-ROLL:**  
[Open on a crowded Excel sales spreadsheet with many rows and columns. Quick zoom out, then transition to a clean pivot table summary. Highlight the before-and-after contrast.]

---

## INTRO

**NARRATION:**  
If you’re a new marketing analyst, you’ll probably work with campaign, lead, or sales data all the time. Pivot tables help you quickly answer questions like: Which region sold the most? Which product performed best? And how do sales change by month? Let’s walk through the basics using a sales spreadsheet.

**ON-SCREEN TEXT:**  
Why use a Pivot Table?  
- Summarize large datasets  
- Spot trends fast  
- Filter results easily

**VISUAL/B-ROLL:**  
[Show a marketing analyst at a laptop. Cut to Excel sheet with columns like Date, Region, Product, Sales Rep, Units Sold, Revenue.]

---

## LEARNING OBJECTIVES

**NARRATION:**  
By the end of this tutorial, you’ll be able to create a pivot table from a sales spreadsheet, filter the data to answer specific questions, and apply simple formatting so your summary is easy to read.

**ON-SCREEN TEXT:**  
You’ll learn to:  
1. Create a Pivot Table  
2. Filter Pivot Table data  
3. Format it for readability

**VISUAL/B-ROLL:**  
[Checklist animation appears beside the Excel window.]

---

## MAIN CONTENT

### MODULE 1: Prepare and insert the Pivot Table

**NARRATION:**  
Start by clicking anywhere inside your sales data. Make sure your spreadsheet has clear column headers and no completely blank rows. Then go to the **Insert** tab and select **PivotTable**. Excel should automatically select your data range. Choose **New Worksheet**, then click **OK**.

**ON-SCREEN TEXT:**  
Step 1: Insert > PivotTable  
- Click any cell in the dataset  
- Check headers and blank rows  
- Place PivotTable in New Worksheet

**VISUAL/B-ROLL:**  
[Cursor clicks inside dataset. Highlight headers: Date, Region, Product, Units Sold, Revenue. Cursor moves to Insert tab > PivotTable. Dialog box appears with selected range and “New Worksheet” chosen. Click OK.]

---

### MODULE 2: Build the Pivot Table layout

**NARRATION:**  
Now you’ll see the PivotTable Fields panel. This is where the magic happens. To summarize revenue by region, drag **Region** into the **Rows** area, and drag **Revenue** into **Values**. Excel will instantly total revenue for each region.

If you want a more detailed view, drag **Product** under **Region** in the **Rows** area. Now you can see revenue by region and product.

**ON-SCREEN TEXT:**  
Build your summary  
- Rows: Region  
- Values: Revenue  
Optional: Add Product under Region

**VISUAL/B-ROLL:**  
[Show PivotTable Fields pane. Drag Region to Rows. Drag Revenue to Values. Table populates. Then drag Product below Region in Rows. Expand hierarchy to show grouped detail.]

---

### MODULE 3: Adjust value settings if needed

**NARRATION:**  
One quick tip: check how Excel is summarizing your numbers. In most sales reports, you’ll want **Sum of Revenue**, not **Count of Revenue**. If it looks wrong, click the drop-down next to the field in **Values**, choose **Value Field Settings**, and select **Sum**.

**ON-SCREEN TEXT:**  
Check Values  
Use: Sum of Revenue  
Not: Count of Revenue

**VISUAL/B-ROLL:**  
[Zoom in on Values area. Open Value Field Settings. Click Sum. Pivot table updates.]

---

### MODULE 4: Filter the Pivot Table

**NARRATION:**  
Next, let’s filter the data. Drag **Sales Rep** or **Date** into the **Filters** area. Then use the filter dropdown at the top of the pivot table to narrow your view. For example, you could show results for one sales rep or one time period.

You can also filter directly in the row labels. Click the dropdown next to **Region** to show only specific regions.

**ON-SCREEN TEXT:**  
Add filters  
- Filters area: Sales Rep or Date  
- Row filter: Region dropdown

**VISUAL/B-ROLL:**  
[Drag Date into Filters. Open dropdown and select one month or quarter. Then open Region dropdown and select two regions. Pivot table updates live.]

---

### MODULE 5: Format the Pivot Table

**NARRATION:**  
Finally, let’s make it easier to read. Click anywhere in the pivot table, then go to the **PivotTable Design** tab. Choose a built-in style you like. To format revenue, right-click any number, choose **Number Format**, select **Currency**, and set your decimals.

This makes your summary cleaner and more professional, especially when you’re sharing it with a manager or adding it to a report.

**ON-SCREEN TEXT:**  
Format for readability  
- PivotTable Design > Style  
- Number Format > Currency

**VISUAL/B-ROLL:**  
[Apply a clean blue PivotTable style. Right-click value cell > Number Format > Currency. Numbers update with dollar signs and commas.]

---

## RECAP

**NARRATION:**  
Let’s review. First, click inside your data and insert a pivot table. Next, drag fields into **Rows**, **Values**, and optionally **Filters** to build your summary. Then check that your values are using the right calculation, like **Sum**. Finally, apply a style and number formatting so your pivot table is easy to read.

**ON-SCREEN TEXT:**  
Pivot Table in 4 steps  
1. Insert  
2. Build  
3. Filter  
4. Format

**VISUAL/B-ROLL:**  
[Fast visual recap of each step with quick callouts: Insert tab, field panel, filter dropdown, design formatting.]

---

## CTA

**NARRATION:**  
Now it’s your turn. Open a sales spreadsheet and build a pivot table to answer one simple question, like which region had the highest revenue. The more you practice, the faster this will feel. Once you’ve done one, you’ll use them everywhere.

**ON-SCREEN TEXT:**  
Try it now:  
Build a Pivot Table from your sales data  
Question to answer: Which region had the highest revenue?

**VISUAL/B-ROLL:**  
[End on completed pivot table with top-performing region highlighted. Friendly closing screen with Excel workbook in background.]

Of course! Here is a complete video script for a tutorial on creating pivot tables in Excel, designed for new marketing analysts.

***

### **Excel for Marketers: Mastering the Pivot Table**

**Video Length:** Approx. 3 minutes
**Tone:** Friendly, encouraging, and professional

---

### **HOOK**

**(0:00 - 0:15)**

**VISUAL/B-ROLL:** [Video opens with a fast-paced montage of a massive, intimidating spreadsheet with thousands of rows of sales data. The screen scrolls quickly, looking overwhelming. Then, it cuts to a friendly host (or just a clean screen with the video title).]

**ON-SCREEN TEXT:** Drowning in Data?

**NARRATION:**
Feeling buried in a spreadsheet full of sales data? You know the answers to your marketing questions are in there somewhere, but finding them feels impossible. What if I told you there’s a tool that can find those answers in

**HOOK**  
**NARRATION**  
"Hey, marketing analyst! Drowning in sales data but can't spot trends fast? Pivot tables are your superpower—let's turn chaos into insights in minutes!"  
**ON-SCREEN TEXT**  
"Unlock Sales Insights FAST with Pivot Tables!"  
[Upbeat music fades in. Quick cuts: Messy Excel spreadsheet zooms to clean pivot table summary. Smiling analyst high-fives screen. Excel icon sparkles.]

**INTRO**  
**NARRATION**  
"Hi, I'm your Excel guide! Today, we'll build, filter, and format a pivot table from a sales spreadsheet. You've got basic Excel skills—this will be a breeze. Let's dive in!"  
**ON-SCREEN TEXT**  
"Build Your First Pivot Table  
New Marketing Analysts Welcome!"  
[Screen recording starts: Open sample sales spreadsheet with columns: Date, Region, Product, Quantity, Sales. Friendly animated cursor waves.]

**LEARNING OBJECTIVES**  
**NARRATION**  
"By the end, you'll:  
1. Create a pivot table from sales data.  
2. Add filters to focus on key trends.  
3. Format it for pro reports.  
Ready? You've got this!"  
**ON-SCREEN TEXT**  
"What You'll Learn:  
• Create a pivot table  
• Filter data  
• Format for reports  
✅ Let's Go!"  
[On-screen bullets animate in one by one. Checkmarks appear. B-roll: Enthusiastic thumbs-up emoji, clock ticking to show 3-min speed.]

**MAIN CONTENT**  

**Module 1: Insert Your Pivot Table**  
**NARRATION**  
"Start with your sales data selected—click and drag from A1 to E20. Go to Insert tab, click PivotTable. Choose 'New Worksheet' and hit OK. Boom—your pivot playground is ready!"  
**ON-SCREEN TEXT**  
"Step 1: Insert PivotTable  
1. Select data (A1:E20)  
2. Insert > PivotTable  
3. New Worksheet > OK"  
[Live Excel demo: Slow, clear mouse movements highlight data selection, ribbon clicks. PivotTable Fields pane pops up with confetti animation.]

**Module 2: Build It—Drag Fields**  
**NARRATION**  
"In the PivotTable Fields pane, drag 'Region' to Rows, 'Product' to Columns, and 'Sales' to Values—it auto-sums! Watch totals appear. Easy, right?"  
**ON-SCREEN TEXT**  
"Step 2: Build Layout  
• Rows: Region  
• Columns: Product  
• Values: Sum of Sales"  
[Demo: Drag-drop animations glow. Table builds live—sales grid forms with numbers filling in. Encouraging "Great!" pop-up.]

**Module 3: Filter for Insights**  
**NARRATION**  
"Drag 'Date' to Filters. Click the dropdown, uncheck old dates—filter to last quarter. See trends pop? Filter by Region too for laser focus!"  
**ON-SCREEN TEXT**  
"Step 3: Add Filters  
• Filters: Date (dropdown)  
• Select recent dates  
• Try Region filter"  
[Demo: Filter dropdown expands, checkboxes tick off. Table updates dynamically. Highlighted filtered data with spotlight effect.]

**Module 4: Format Like a Pro**  
**NARRATION**  
"Right-click a value, Format Cells > Currency. Then, PivotTable Design tab > pick a style. Add bold totals—your report shines! Nailed it!"  
**ON-SCREEN TEXT**  
"Step 4: Format  
• Right-click > Format Cells > $ Currency  
• Design tab > Style  
• Bold totals"  
[Demo: Right-click glows, menu paths highlight. Styles gallery previews. Final polished table zooms out with shine effect.]

**RECAP**  
**NARRATION**  
"Quick recap: Select data, Insert PivotTable, drag fields, filter smartly, format pro. You just mastered pivot tables—sales insights await!"  
**ON-SCREEN TEXT**  
"Recap:  
1. Insert  
2. Build  
3. Filter  
4. Format  
You're a Pivot Pro! 🎉"  
[Montage: Speed-run of all steps. Final pivot table screenshot with checkmarks overlay.]

**CTA**  
**NARRATION**  
"Pause now—try it on your data! Like, subscribe for more analyst hacks, and comment your wins. You've got the skills—go crush those reports!"  
**ON-SCREEN TEXT**  
"Practice Now!  
👍 Like & Subscribe  
💬 Comment: Your First Pivot?  
#ExcelForMarketers"  
[Energetic music swells. Screen: Download sample file link. Thumbs-up animation, subscribe bell. Fade to channel logo.]