GROUPBY & PIVOTBY Array Functions For Excel Worksheet Reporting

by excelisfun · 8 videos

Total watch time

1h 14m

at 1× speed · exactly 1 hour, 13 minutes, 54 seconds at 1×

custom

1×	1h 13m 54s
1.25×	59m 7s
1.5×	49m 16s
1.75×	42m 14s
2×	36m 57s

Average video9m 14s

Longest51m 23s

Shortest1m 23s

Compare Open on YouTube JSON

Plan to finish

About 2 days at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

At one hour a day, every day, this playlist takes about 2 days. Turn on JavaScript to plan around your week.

Videos (8)

1h 14m in total · tick what you've watched

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


1	MS 365 Excel Basics 09: PIVOTBY & GROUPBY Functions Beat PivotTable: 10 Mind-Blowing Examples!	51:23	2025-03-30
2	MS 365 Excel Basics #10 Part 04: GROUPBY Array Function to Calculate the Percent of Count Total	3:28	2025-04-13
3	Mind-Blowing: GROUPBY Function Beats PivotTable, Hands-down. Beats COUNTIFS Too! Excel Short # 75	1:50	2025-03-30
4	Temporary Fix for GROUPBY Function & Single Cell Reporting Formula Excel Chart Bug? EMT 1881	1:23	2025-03-28
5	GROUPBY Function & Single Cell Reporting Formula Excel Chart Bug? Insert Column & Chart Breaks?	2:11	2025-03-27
6	PIVOTBY & LAMBDA Functions to Covert Bad Data Into Proper Table, When There Are Duplicates. EMT 1877	2:21	2025-03-09
7	Unbelievable PIVOTBY & SINGLE Functions to Covert Bad Data Into Proper Table. Excel Magic Trick 1876	2:33	2025-03-08
8	Mind Blowing GROUPBY Function Reporting Trick with BYROW & LAMBDA eta AND. Excel Magic Trick 1911	8:45	2025-10-03

Embed a badge

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

Markdown

[![Watch time: 1h 14m · 8 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0krtFaQ4vgZhyMsrllSSYmX.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0krtFaQ4vgZhyMsrllSSYmX)

HTML

<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0krtFaQ4vgZhyMsrllSSYmX"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0krtFaQ4vgZhyMsrllSSYmX.svg" alt="Watch time: 1h 14m · 8 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/PLrRPvpgDmw0krtFaQ4vgZhyMsrllSSYmX 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.