I'm not arguing that PivotTables are now useless, because they still solve certain problems very well. However, after seeing how fluid, responsive, and adaptable GROUPBY and PIVOTBY can be, I've found ...
Some of Excel’s most powerful modern features simply do not work inside tables. Dynamic array formulas, often called spill ...
Research from to Datarails (via The Register) found over half (54%) of finance professionals aged 22 to 32 report "loving" Excel, a higher proportion than among older generations, where 39% express ...