Playlist Duration

Playlist · excelisfun

Single Cell Formula Reporting in the Excel Worksheet

by excelisfun · 45 videos

Total watch time

7h 10m

at 1× speed · exactly 7 hours, 9 minutes, 47 seconds at 1×

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

The shape of the course

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

1h 47m
1h 16m
1h 50m
1h 14m
1h 4m

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 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 (45)

7h 10m 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 LET Function for Dynamic Reporting in Single Cell. Excel Magic Trick 1673 7:01 2020-06-22
2 Single Cell Spilled Reports with Dynamic Total Row & Formatting. Excel Magic Trick 1703. 24:50 2020-11-23
3 LAMBDA Excel Function. LET & LAMBDA together to make Single Cell Reports. Excel Magic Trick 1706 5:26 2020-12-04
4 LET Function Advanced Array Formula for Dynamic Cross Tabulated Report. Excel Magic Trick 1681. 14:32 2020-08-03
5 Sorted Frequency Distribution with the LET Function. Excel Magic Trick 1675. 6:01 2020-07-01
6 FREQUENCY Array Function for Quantitative Data. LET function to create full report! EMT 1693. 13:30 2020-10-05
7 Single Cell Yearly Sales Report Formula. 4 Examples. New LET Function!!! Excel Magic Trick 1652 5:42 2020-03-24
8 Excel Dynamic Arrays: Cross Tabulated Report, Totals Top & Left MMULT Array Function (EMT 1526) 7:29 2018-11-05
9 Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports With Totals!!!!! EMT 1528 13:02 2018-10-28
10 Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports? Unbelievable! EMT 1520 9:16 2018-10-24
11 Excel Dynamic Arrays or Mixed Cell References for Cross Tabulated Reports? EMT 1518 7:44 2018-10-23
12 7 LAMBDA Helper Functions: MAP, SCAN, BYCOL, BYROW, REDUCE, ISOMITTED, MAKEARRAY. EMT 1749 16:30 2021-08-17
13 Spilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750 3:04 2021-08-24
14 VLOOKUP, MAP & LAMBDA functions to spill a Two-Way Lookup Formula Excel Magic Trick 1760 4:33 2021-10-11
15 INDEX & XMATCH functions to spill a Two-Way Lookup Formula. Excel Magic Trick 1760 Part 2. 2:09 2021-10-12
16 Single Cell Reporting to Spill MEDIAN and SUM Results using BYROWS & LAMBDA. Excel Magic Trick 1763 12:37 2021-10-27
17 Excel PivotTable or Formula to Count Unique Dates for Each New Item. 4 Examples. EMT 1767 9:49 2021-12-20
18 Mode for Categorical Data? LET Function to Dynamically List all Modes with Category Labels EMT 1770 6:35 2022-01-01
19 FILTER, LET, TRANSPOSE and Other Excel Functions: Mode Calculation for each Quartile. EMT 1771 7:13 2022-01-13
20 HSTACK and VSTACK Functions to Create Single Cell Reports With Total Row. Excel Magic Trick 1780 5:34 2022-03-16
21 HSTACK and VSTACK Functions: Create Cross Tabulated Report With Total Rows. Excel Magic Trick 1781 11:30 2022-03-18
22 14 New Excel Worksheet Functions That Will Blow Your Mind! Excel Magic Trick 1782 18:35 2022-03-19
23 Combine All Tables in Excel Workbook: VSTACK or Excel.CurrentWorkbook Function? EMT 1783 8:29 2022-03-22
24 WRAPCOL & SORTBY Array Functions to Pivot A Table. "Robustify" your formulas! Excel Magic Trick 1784 3:38 2022-03-23
25 TOCOL, DROP, EXPAND Array Functions to UnPivot Data into Proper Table. Excel Magic Trick 1785 10:20 2022-03-24
26 VSTACK & 3-D References: Combine Worksheet Data into One Table!!!! Excel Magic Trick 1786 6:29 2022-03-25
27 Single Cell Excel Reporting with LET, LAMBDA, VSTACK, SUMIFS & More, Complete Lesson! EMT 1787 18:07 2022-03-28
28 DROP, TAKE & VSTACK: How They Are Useful! Spilled Frequency Distribution with Total Row. EMT 1788 12:14 2022-03-31
29 Unique List of Case Sensitive Items? Expandable Range in Spilled Array Formula? EMT 1792 12:05 2022-05-31
30 UnPivot Cross Tabulated Table with Power Query or Dynamic Spilled Array Formula? EMT 1805 8:06 2022-11-29
31 GROUPBY Excel Worksheet Function. Single Cell Reports Made Easy! 11 Examples. EMT 1844 28:33 2023-11-18
32 2 Different Functions in GROUPBY & PIVOTBY Functions. Excel Magic Trick 1844 Part 2 3:07 2023-11-18
33 Excel PIVOTBY Function to Create Completely Dynamic PivotTable Formula Reports! EMT 1845 19:34 2023-11-20
34 ETA-LAMBDAs for BYROW, BYCOL & SCAN to Make Spilling Row Totals & Running Totals Easy. EMT 1846 2:29 2023-11-19
35 Append Tables in Excel. Excel Magic Trick 1852 1:08 2024-02-19
36 Formula for Sales Rep by Month Report: The Amazing GROUPBY Function! Excel Magic Trick 1853 2:14 2024-02-22
37 PIVOTBY & GROUPBY to Create Year by Month Sales Report. Grouping Trick! Excel Magic Trick 1859 2:48 2024-03-25
38 Grouping in GROUPBY & PIVOTBY Functions!?!? Yes!!!! Frequency Distribution with GROUPBY EMT 1858 3:10 2024-03-18
39 GROUPBY Function to Group Transactions with No Transaction Number. EMT 1855 5:59 2024-02-29
40 Excel Formula to Create Inventory Reorder List from Multiple Tables. VSTACK & FILTER Fun! EMT 1899 4:54 2025-06-24
41 COUNTIFS, GROUPBY & LET Functions: Create Amazing Single Cell Dynamic Spilled Array Report. EMT 1901 24:46 2025-08-15
42 The Magic of Excel’s REDUCE & LAMBDA Functions to Split Values & Spill an Array of Arrays! EMT 1908 7:43 2025-09-16
43 Mind Blowing GROUPBY Function Reporting Trick with BYROW & LAMBDA eta AND. Excel Magic Trick 1911 8:45 2025-10-03
44 FILTER function AND Logical Test made Easy with BYROW & AND functions! Excel Magic Trick 1912 12:11 2025-10-13
45 Amazing BYROW Function in FILTER Function Make Dynamic Filtering by OR Logical Test Easy! EMT 1913 10:16 2025-10-13
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: 7h 10m · 45 videos

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

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