PivotTables remain one of Excel’s most powerful tools for quick data analysis, but they’re not always the perfect fit.

Excel specialists are increasingly highlighting the PIVOTBY function for creating dynamic, formula-based summaries that update automatically. PivotTables still serve important roles in exploration and ...