Playlist Duration

Playlist · excelisfun

What's New in Excel 2016 Playlist of Videos

by excelisfun · 67 videos

Total watch time

19h 17m

at 1× speed · exactly 19 hours, 16 minutes, 30 seconds at 1×

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

The shape of the course

67 videos in blocks of 10 · each column is a block's total, to scale

1h 27m
1h 46m
6h 15m
2h 12m
3h 11m
1h 44m
2h 40m

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

Videos (67)

19h 17m 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 Basic Excel Business Analytics #26: Box & Whisker Plot. Chart Example in Excel 2016. 5:22 2015-10-10
2 Basic Excel Business Analytics #30: Excel 2016 Power Query: Data Ribbon Tab, Get and Transform 5:14 2015-10-19
3 Basic Excel Business Analytics #37: Excel 2016 Data Tab, Get & Transform: Unpivot feature 6:52 2015-10-21
4 Basic Excel Business Analytics #41: Excel 2016: Introduction to PowerPivot & Data Model 10:53 2015-10-28
5 Excel Magic Trick 1249: Build Database with Excel 2016 Table feature & VLOOKUP to Get Invoice Detail 25:46 2016-01-05
6 Excel Magic Trick 1263: Power Query M Code: 10 Cross Tabulated Transformed into 1 Proper Data Set 11:21 2016-01-25
7 Excel Magic Trick 1267: PivotTable Automatic Date Grouping: New in Excel 2016 3:20 2016-01-31
8 Excel Magic Trick 1268: Excel 2016 Auto Detect Relationships: 2 Tables In PivotTable Field List 6:27 2016-02-01
9 Excel Magic Trick 1269: Excel 2016: Without Power Pivot: DAX Measures, Relationships & Data Model 10:09 2016-02-03
10 Excel Magic Trick 1275: Excel Online Office 365 MAXIFS function 1:58 2016-02-11
11 Excel Magic Trick 1276: Impossible: Excel Online Absolute Cell References? 1:54 2016-02-11
12 Excel Magic Trick 1280: How To Get Latest Excel Updates for Insider Program: Office 365 2:40 2016-02-20
13 Excel Magic Trick 1281: TEXTJOIN & CONCAT New Excel 2016 functions (14 Examples of Joining Items) 10:54 2016-02-20
14 Excel Magic Trick 1282: Lookup And Return Multiple Items to a Single Cell: TEXTJOIN Function 5:12 2016-02-23
15 Excel Magic Trick 1283: MINIFS & MAXIFS Excel 2016 Functions: Max or Min with Conditions / Criteria 8:42 2016-02-25
16 Excel Magic Trick 1285: OR Criteria & AND Criteria for Max & Min Calculations (5 Examples) 19:49 2016-02-29
17 Excel Magic Trick 1286: Excel 2016 IFS Functions (9 Examples: Compare & Contrast IF & IFS Functions) 28:21 2016-03-03
18 Excel Magic Trick 1287: SWITCH Function: How to Lookup Formulas, References, or Anything Else 17:52 2016-03-05
19 Excel Magic Trick 1292: Power Query Unpivot into Proper Lookup Table to Score Myers-Briggs Test 7:17 2016-03-17
20 Excel Magic Trick 1295: TEXTJOIN & INDEX Function to create Random Description Codes 3:46 2016-03-21
21 Highline Excel 2016 Class 02: Excel Fundamentals: Comprehensive Formula Lesson (15 Examples) 55:03 2016-04-09
22 Highline Excel 2016 Class 01: Excel Fundamentals: Efficiency, Data, Data Sets, Formatting 1:21:10 2016-04-06
23 Highline Excel 2016 Class 03: Data Analysis Fundamentals: PivotTables, Power Query & Data Model 1:43:05 2016-04-17
24 Highline Excel 2016 Class 07 Excel 2016 MAXIFS, MINIFS & IFS Functions for Conditional Calculations 11:04 2016-05-10
25 Highline Excel 2016 Class 14: VLOOKUP as Relationship in Power Pivot Data Model & Vice Versa 8:02 2016-05-17
26 Highline Excel 2016 Class 17: How to Build Excel Dashboard PivotTable, Chart, Conditional Formatting 36:16 2016-05-27
27 Highline Excel 2016 Class 21: Power Query Import Multiple Excel Workbooks with Multiple Sheets 9:06 2016-06-10
28 Highline Excel 2016 Class 22: How To Build Data Model & DAX Formulas in Power Pivot 1:04:43 2016-06-23
29 Excel Magic Trick 1298: Group By Date in Power Pivot Data Model, New in Excel 2016 2:49 2016-07-01
30 Excel Magic Trick 1299: Automatic Calendar Table in Data Model, New in Excel 2016 3:47 2016-07-01
31 Highline Excel 2016 Class 23: Intro to Power BI Desktop to Create Data Model & Visualization 24:29 2016-07-01
32 Excel Magic Trick 1300: List All Modes in Single Cell with TEXTJOIN & MODE.MULT 4:21 2016-07-10
33 Excel Magic Trick 1303: Minimum Value Greater Than Zero (3 Examples) 6:04 2016-07-15
34 Excel Magic Trick 1308: Concatenate Items in Rows & Columns from Two-Way Table with TEXTJOIN 2:26 2016-07-21
35 Excel Magic Trick 1315: Create A Unique Sorted List with Power Query 4:16 2016-08-22
36 Excel Magic Trick 1316: VLOOKUP with Multiple Lookup Tables: IF, INDIRECT, SWITCH, IFS, or CHOOSE? 15:52 2016-08-31
37 Excel Magic Trick 1318: Unique Visitors To Site Each Day? Data Model PivotTable or Array Formula? 12:38 2016-09-03
38 Excel Magic Trick 1322: Backwards One To Many Relationship Report: Excel, Power Query or SQL? 30:37 2016-09-13
39 Excel Magic Trick 1328: Case Sensitive Filtering, Adding or Counting: Power Query (Get & Transform) 6:55 2016-10-09
40 Excel Magic Trick 1326: Conditionally Format Text Modes: PivotTable, Array Formula or Power Query? 24:51 2016-10-04
41 Excel Magic Trick 1329: Clean Data Then Add w 2 Criteria: SUMIFS or Power Query (Get & Transform)? 12:33 2016-10-12
42 Excel Magic Trick 1330: Append All Excel Tables in Current Workbook: Power Query (Get & Transform) 28:34 2016-10-13
43 Excel Magic Trick 1331: Import Multiple Excel Files & Sheets into Excel: Power Query Get & Transform 29:48 2016-10-16
44 Excel Magic Trick 1332: Power BI Desktop: Import Multiple Excel Files & Build Dashboard 15:23 2016-10-19
45 Excel Magic Trick 1333: Power Query (Get & Transform) Rounding: Banker's or Gaussian Rounding 10:31 2016-10-23
46 Excel Magic Trick 1334: Power Query or Formula: Lookup Name Based on Max Value and more… 14:14 2016-10-25
47 Excel Magic Trick 1336: Power Query: Import Big Data Text Files: Connection Only or Data Model? 11:35 2016-10-27
48 Excel Magic Trick 1338: Power Query: Unpivot 12 Cross Tabulated Tables into One Proper Data Set 24:00 2016-10-31
49 Excel Magic Trick 1341: Standard Deviation with Criteria: Power Query, PivotTable, or Array Formula? 26:24 2016-11-07
50 Excel Magic Trick 1349: Power Query with Input Variables from Excel Sheet to Extract Records 18:02 2016-11-21
51 Excel Magic Trick 1347: Power Query Function: Split Master Table into Sub Tables for Each Product 21:05 2016-11-18
52 Excel Magic Trick 1351: Power Query: Merge Text & Excel Files, Custom Columns, Total Row & Slicer 21:20 2016-11-29
53 Excel Magic Trick 1353: Power Query: Extract Records w Merge Feature & Inner Join on Parameter Table 12:23 2016-12-02
54 Excel Magic Trick 1413: Set Default Layout in a PivotTable (New in Excel 2016, Office 365) 3:17 2017-05-03
55 Excel Magic Trick 1423: Power Query Number.ToText Function to Format Numbers as Text 9:15 2017-05-16
56 Excel Magic Trick 1422: Power Query M Code: Join all Items From Invoice into One Cell 4:33 2017-05-16
57 Excel Magic Trick 1421: Get Help for Power Query Functions 2:22 2017-05-16
58 Excel Magic Trick 1436 Excel 2016: Combine 2 BIG Tables into 1 for PivotTable Report, No Power Pivot 7:05 2017-05-27
59 Excel Magic Trick 1439: DAX Measures to Create Cross Tabulated OR & AND Logical Test Sales Total 6:52 2017-05-30
60 Excel Magic Trick 1440: OR Logical Test on 2 Columns using DAX IN Operator & DAX OR Function 16:16 2017-05-31
61 Excel Magic Trick 1442 DAX Query & EXCEPT Function to Extract Items In List 1 That Are NOT In List 2 8:54 2017-06-21
62 Excel Magic Trick 1450: Replace VLOOKUP When Making PivotTables with Excel 2016 Relationships 10:20 2017-07-31
63 Excel Magic Trick 1451: Hack Data Model, Date Table & DAX Measures WITHOUT buying Power Pivot 35:56 2017-08-03
64 Excel Magic Trick 1451: Hack Data Model, Date Table & DAX Measures WITHOUT buying Power Pivot 35:56 2017-08-03
65 Excel Magic Trick 1460: List All Relative Positions in a Single Cell using TEXTJOIN Array Formula 12:24 2017-09-01
66 Excel Magic Trick 1463: Show Formula in Cell With Excel Functions FORMULATEXT & ISFORMULA 5:59 2017-09-12
67 Introduction to Power Query & Power Pivot Data Model in Excel 2016 (Excel Magic Trick 1468) 50:06 2017-10-06
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: 19h 17m · 67 videos

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

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