playlistduration

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×

1×19h 16m 30s
1.25×15h 25m 12s
1.5×12h 51m
1.75×11h 51s
2×9h 38m 15s
Average video17m 16s
Longest1h 43m 5s
Shortest1m 54s
Compare Open on YouTube JSON

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.

Videos to
Watched
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

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-09-22 (cached). Private or deleted videos are excluded from totals.