Playlist Duration

Playlist · Leila Gharani

Excel Power Query (Get & Transform)

by Leila Gharani · 21 videos

Total watch time

4h 6m

at 1× speed · exactly 4 hours, 6 minutes, 19 seconds at 1×

At an hour a day you'd finish in 5 days

The shape of the course

Each column is one video, to scale

27:01

WatchedTo watch

Compare Open on YouTube JSON

Next time, skip the copying: change youtube.com to playlistduration.com in any playlist, video or channel address and it opens here. Or see the total on YouTube itself, with our extension for Chrome, Firefox or Edge.

Your plan

Plan to finish

About 5 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 5 days. Turn on JavaScript to plan around your week.

Videos (21)

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

Tick videos you've watched — progress is saved in this browser. Titles open on YouTube in a new tab.

Videos to
Watched Leave out of the total
1 How Power Query Will Change the Way You Use Excel 9:02 2020-06-25
2 Convert Columns to Rows in Excel (NO Transpose, NO Formulas - SIMPLY UNPIVOT in Power Query) 5:00 2019-09-19
3 Easily Import Data from Web to Excel (2 Practical Examples) 10:02 2019-12-12
4 Easiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder) 10:29 2020-05-21
5 How to Split and Transform Text in Excel (Unbelievable Power Query Tricks) 10:54 2020-06-11
6 How to Easily Create a Dynamic Filled Map Chart in Excel with Power Query 8:07 2020-07-02
7 Excel Unpivot Data with Multiple Headers (Multiple Row levels into Columns with Power Query) 13:30 2020-07-16
8 Consolidate & Clean Multiple Excel Sheets in One Pivot Table 9:06 2020-07-30
9 How to Calculate Hours Worked with Excel Power Query (& Properly Sum time) 9:41 2020-08-20
10 Convert PDF to Excel with Power Query (Free, Refreshable) 11:28 2020-10-15
11 How to Merge Excel Files with Different Headers in Power Query | List.Accumulate 17:04 2021-02-18
12 How To Import & Clean Messy Accounting Data in Excel | Use Power Query to Import SAP Data 20:38 2021-03-04
13 How to Import Emails From OUTLOOK to EXCEL & why you want to do that! 7:04 2021-05-13
14 Get a Free Library as you Learn Excel Power Query Tricks (Custom data types, Hyperlink data type!) 11:07 2021-06-03
15 3 Ways to Switch Data in Columns to Rows in Excel (Multiple Values) 17:08 2021-07-29
16 How to Combine and Repeat Blocks of Text n Times in Excel (NO Copy Paste and NO Formulas) 4:26 2021-10-07
17 Bulk Combine PDF files to Excel without losing formatting & NO 3rd party software 9:27 2022-06-16
18 You WON'T BELIEVE These 10 HIDDEN Features in Excel Power Query 🤯 12:17 2023-06-15
19 Master Excel Web Scraping - Learn How to Import Data AND Images (with ZERO Coding) 14:20 2023-12-14
20 Power Query for Beginners: Automate Your Excel Work in 25 Mins 27:01 2025-07-24
21 Power Query Remove Duplicates Keeps the WRONG Record 8:28 2026-06-11
For your README

Embed a badge

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

Watch time: 4h 6m · 21 videos

Markdown
[![Watch time: 4h 6m · 21 videos](https://playlistduration.com/badge/playlist/PLmHVyfmcRKyyKV86N7i0q9TfYNN8bBjX-.svg)](https://playlistduration.com/playlist/PLmHVyfmcRKyyKV86N7i0q9TfYNN8bBjX-)
HTML
<a href="https://playlistduration.com/playlist/PLmHVyfmcRKyyKV86N7i0q9TfYNN8bBjX-"><img src="https://playlistduration.com/badge/playlist/PLmHVyfmcRKyyKV86N7i0q9TfYNN8bBjX-.svg" alt="Watch time: 4h 6m · 21 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/PLmHVyfmcRKyyKV86N7i0q9TfYNN8bBjX- returns them as JSON — free, no key. API docs →

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