playlistduration

Excel Table Feature, including Table Formula Nomenclature / Structured References Playlist

by excelisfun · 36 videos

Total watch time

7h 41m

at 1× speed · exactly 7 hours, 40 minutes, 36 seconds at 1×

1×7h 40m 36s
1.25×6h 8m 29s
1.5×5h 7m 4s
1.75×4h 23m 12s
2×3h 50m 18s
Average video12m 48s
Longest1h 43m 28s
Shortest1m 10s
Compare Open on YouTube JSON

Plan to finish

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

Videos (36)

7h 41m in total · tick what you've watched

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

Videos to
Watched
1 Excel Basics 15: Excel Table Feature & Dynamic Ranges for VLOOKUP, PivotTables, & more! 36:47 2017-11-09
2 Excel Table NOT Automatically Add New Column or Rows? Option Setting to Fix This. Magic Trick 1547 1:10 2019-04-15
3 E-DAB 02: Data, Proper Data Sets, Excel Tables, Logical Tests, More 35:27 2019-02-21
4 Highline Excel 2013 Class Video 08: Excel Table Formula Nomenclature / Structured References 22 Ex. 25:47 2013-10-04
5 Excel Magic Trick 1041: Expandable Range In An Excel Table For Running Total (Zack Barresse's Trick) 3:03 2013-08-14
6 Excel Magic Trick 1024: SUMIF & SUMIFS function & Mixed Cell References & Dynamic Table Range 10:26 2013-07-23
7 Highline Excel 2013 Class Video 13: AND & OR Criteria Calculations: Table Feature 5:34 2013-10-12
8 Excel Magic Trick #200: Excel Table Formula Nomenclature 9:18 2009-01-09
9 Excel Magic Trick 1251: SUMIFS & Table Formula Nomenclature (Structured References) to Add Invoices 4:24 2016-01-10
10 Excel Magic Trick 1037: Make Table Reference Absolute by Copying And Pasting Instead Of Dragging 3:16 2013-08-09
11 Excel Magic Trick 1038: Make Table Reference Absolute With Colon and Double Square Brackets 4:26 2013-08-09
12 Excel Magic Trick 1249: Build Database with Excel 2016 Table feature & VLOOKUP to Get Invoice Detail 25:46 2016-01-05
13 Basic Excel Business Analytics #11: Dynamic Grading Model: Excel Table feature & VLOOKUP 9:50 2015-10-02
14 Office 2013 Class #27: Excel Basics 09: Keeping Data in Excel: Proper Data Set or Excel Table 13:18 2013-10-29
15 Excel Magic Trick 1193: Count Distinct Words As They Are Entered In Column: Formula or Excel Table? 5:58 2015-04-24
16 Excel Magic Trick 1073: Excel Tables & Dynamic Data Extraction Array Formulas, AGGREGATE or SMALL 22:03 2014-02-23
17 Excel Magic Trick 509: VLOOKUP with Dynamic Table using Table Nomenclature 12:01 2010-02-17
18 Highline Excel 2016 Class 04: References: Relative, Absolute, Mixed, Sheet, Workbook, 3-D, Table… 1:43:28 2016-04-26
19 Excel Magic Trick 1344: Conditional Formatting the Entire Row in an Excel Table: Totally Dynamic!! 6:02 2016-11-13
20 Excel Magic Trick 1370 INDEX Function & Number Incrementor Extract Items & Display In Every 3rd Cell 9:27 2017-01-19
21 Excel Magic Trick 1371: Excel Formula To Add Last Five Values in an Excel Table: INDEX Dynamic Range 7:28 2017-01-22
22 Excel Table Column Formulas and Spilled Arrays? Excel Magic Trick 1679 3:38 2020-07-20
23 Create Excel Database and Data Entry Form. Excel Magic Trick 1690. 8:08 2020-09-14
24 Power Query Append / Combine Tables: 3 Amazing Methods. Excel Magic Trick #1714. 13:09 2021-01-08
25 4 New Create PivotTable Dialog Boxes: 4 Amazing Data Sources. Excel Magic Trick 1729. 7:08 2021-03-16
26 PivotTable Formulas? Calculated Field, DAX Formula or Excel Table Formula for Gross Profit? EMT 1730 12:17 2021-03-23
27 Unbelievable New Stock Market Data Tools in Microsoft 365 Excel!!! Excel Magic Trick 1731 6:10 2021-03-30
28 Store Full Table to One Column? Excel Power Query Puts Records in One Cell! Excel Magic Trick1734. 4:38 2021-04-07
29 Organizational Data Types in Excel M365 & Power BI. Excel Magic Trick 1735 3:27 2021-04-09
30 SUMIFS with Dynamic Data Validation List & Conditional Formatting for Row. Excel Magic Trick 1739 5:56 2021-06-08
31 Append “ALL” to Top of Sorted Unique List for Data Validation List for SUMIFS Function. EMT 1740 11:18 2021-06-14
32 Combine All Tables in Excel Workbook: VSTACK or Excel.CurrentWorkbook Function? EMT 1783 8:29 2022-03-22
33 WRAPCOL & SORTBY Array Functions to Pivot A Table. "Robustify" your formulas! Excel Magic Trick 1784 3:38 2022-03-23
34 TOCOL, DROP, EXPAND Array Functions to UnPivot Data into Proper Table. Excel Magic Trick 1785 10:20 2022-03-24
35 Excel Percent of Total Formula: Dynamic Spilled Array or Excel Table? Excel Magic Trick 1882 4:21 2025-04-14
36 Why Data Analysis Needs Proper Tables and Power Query’s UnPivot Feature. Excel Magic Trick 1886 3:00 2025-04-26

Embed a badge

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

Watch time: 7h 41m · 36 videos

Markdown
[![Watch time: 7h 41m · 36 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0kmoAhXamTJw6XkebJ6gCxg.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0kmoAhXamTJw6XkebJ6gCxg)
HTML
<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0kmoAhXamTJw6XkebJ6gCxg"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0kmoAhXamTJw6XkebJ6gCxg.svg" alt="Watch time: 7h 41m · 36 videos" width="203" 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/PLrRPvpgDmw0kmoAhXamTJw6XkebJ6gCxg 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.