Excel GROUPBY and PIVOTBY: An alternative to Pivot Tables? + How I crashed Excel with PIVOTBY

Опубликовано: 07 Июль 2026
на канале: Upskill Office

2,095

53

The GROUPBY and PIVOTBY functions are now available in the Current Channel release of Excel in MS365. Here I talk about how to use their arguments to create advanced analysis formula, and their pros and cons versus pivot tables.

00:00 - Intro
00:34 - The basics of GROUPBY
03:24 - Advanced GROUPBY
14:49 - PIVOTBY
15:57 - How to crash Excel with PIVOTBY 🤣

Intro music: "Pitbull" by Michael Ramir C.
https://mixkit.co/

#microsoft #ms365 #msoffice #office #excel #groupby #pivotby #pivottables #dynamicarrays

नियोजित एवम BPSC शिक्षको में बहस।

नियोजित एवम BPSC शिक्षको में बहस।

Мы верим твёрдо в героев спорта, нам победа, как воздух, нужна. Гимн российских спортсменов

Мы верим твёрдо в героев спорта, нам победа, как воздух, нужна. Гимн российских спортсменов

GENSHIN IMPACT : Thunder Sojourn

GENSHIN IMPACT : Thunder Sojourn

4 Ways to Prevent Malware Attacks

4 Ways to Prevent Malware Attacks

A (deeper) dive into DuckDB using DuckDB CLI and VSCode - PART 3 (duckDB cool features)

A (deeper) dive into DuckDB using DuckDB CLI and VSCode - PART 3 (duckDB cool features)

Android phone best useful calling tricks and tips.

Android phone best useful calling tricks and tips.

The Benefits of Using AI-Enabled Digital Twins with Suzette Johnson and Robin Yeman

The Benefits of Using AI-Enabled Digital Twins with Suzette Johnson and Robin Yeman

INFINITE MISERY - Promo 2023 Full tracks

INFINITE MISERY - Promo 2023 Full tracks