These Excel functions just made PivotTables obsolete for me

You’d think that PivotTables are the easiest and least stressful way to summarize data in Excel. For a long time, I believed that, too. That changed once I got comfortable enough using GROUPBY and PIVOTBY. These functions let me build summaries that behave like living parts of my worksheet rather than isolated report islands that need to be refreshed, rebuilt, or tweaked every time the underlying data changes.