pivottables

A new How-To Geek report argues that Excel’s PIVOTBY function still cannot fully replace PivotTables in polished, refreshable reports—not because of calculation limits, but because conditional formatting does not reliably follow a changing spill range. PIVOTBY is Microsoft’s formula-based tool...

For quick, one-off questions about a spreadsheet, speaking in plain English to Copilot in Excel can be faster and less fiddly than building a PivotTable — and for many routine analysis tasks it gives the same answers without the clicks. Background PivotTables have been Excel’s go-to interactive...

Microsoft has quietly changed how Excel behaves in a handful of small but consequential ways — most visibly by shifting PivotTable overlap alerts into the familiar #SPILL! error model and by introducing value tokens that make rich data types visible in the grid and formula bar — moves Microsoft...

Microsoft’s latest Excel headlines have been dominated by bold AI stunts — Copilot, on-cell generative functions and natural‑language formulaing — but one of the oldest, most reliable features in the spreadsheet deserves a second look: PivotTables. Used judiciously, PivotTables remain the...

Microsoft Excel users are entering a new era of productivity this August, as fresh features arrive across Windows, Mac, and the web—moving the world’s leading spreadsheet platform ever closer to a seamless, modern, and highly collaborative experience. These updates, mainly available to Microsoft...