playlistduration

Excel Flash Fill Data Cleaning Tricks, Playlist of Videos

by excelisfun · 15 videos

Total watch time

5h 6m

at 1× speed · exactly 5 hours, 5 minutes, 47 seconds at 1×

1×5h 5m 47s
1.25×4h 4m 38s
1.5×3h 23m 51s
1.75×2h 54m 44s
2×2h 32m 54s
Average video20m 23s
Longest1h 25m 17s
Shortest2m
Compare Open on YouTube JSON

Plan to finish

About 6 days at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

Days

At one hour a day, every day, this playlist takes about 6 days. Turn on JavaScript to plan around your week.

Videos (15)

5h 6m in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser.

Videos to
Watched
1 Highline Excel 2013 Class Video 29: Flash Fill: Extract, Combine, Insert, Reverse Data (25 Example) 12:22 2013-11-08
2 Office 2013 Class #34: Excel Basics 16: Flash Fill To Combine or Extract Text 4:00 2013-10-31
3 Excel Magic Trick 1261: Flash Fill to Add Spaces to Credit Card Numbers 2:00 2016-01-23
4 Excel Magic Trick 1177: Flash Fill or CODE Formula Split First Last Name Based on 2nd Capital Letter 8:22 2015-03-09
5 Excel 2013 Preview #2: Flash Fill To Extract First & Last Names From Column (Excel Magic Trick 950) 2:11 2012-07-23
6 Excel 2013 Flash Fill : 23 Amazing Examples (Preview #7) (Excel Magic Trick 955) 9:17 2012-07-25
7 Excel Magic Trick 1475: Power Query, Formula, Flash Fill: "1-PSD/AFX-12" into "12-AFX/PSD-1" 10:59 2017-12-31
8 Excel Basics 23: Data Analysis Features: Sort, Filter, Flash Fill to Organize & Clean Data 30:08 2017-11-21
9 The Magic of Excel: Formulas, PivotTables, Charts, Flash Fill, Sort, Filtering, Functions & more!! 1:01:43 2017-06-27
10 Highline Excel 2016 Class 18: Clean & Transform Data: Replace, Flash Fill, Text To Columns, Formulas 24:14 2016-06-03
11 Excel Magic Trick 1289: Remove “USD” from CSV File Column of Numbers (6 Examples) 14:39 2016-03-11
12 Basic Excel Business Analytics #27: Clean & Transform Data: Formulas, Flash Fill, Power Query, TTC 29:49 2015-10-18
13 Excel Magic Trick 1183: Remove All Text after Dash: Flash Fill, Text To Columns, Text Formula 4:23 2015-03-25
14 Mr Excel & excelisfun Trick 145: YYYYMMDD Numbers To Dates: TTC, Flash Fill, DATE or TEXT Functions? 6:23 2013-12-21
15 What's New In Excel 2013: Flash Fill, Functions, Data Model, PowerPivot, New Charts, Table Slicers.. 1:25:17 2013-09-04

Embed a badge

Show the watch time in a README or course description — it links back here and updates itself

Watch time: 5h 6m · 15 videos

Markdown
[![Watch time: 5h 6m · 15 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0lSChc0Z21lcY8Tog_sNQGC.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0lSChc0Z21lcY8Tog_sNQGC)
HTML
<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0lSChc0Z21lcY8Tog_sNQGC"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0lSChc0Z21lcY8Tog_sNQGC.svg" alt="Watch time: 5h 6m · 15 videos" width="196" height="20"></a>

Add ?speed=1.5 to the image URL for the time at that speed, ?label=Course to change the left text, or ?style=flat-square for square corners.

Want the numbers themselves? GET https://playlistduration.com/api/v1/playlist/PLrRPvpgDmw0lSChc0Z21lcY8Tog_sNQGC returns them as JSON — free, no key. API docs →

Data from the YouTube Data API as of 2026-09-22 (cached). Private or deleted videos are excluded from totals.