How-To Geek on MSN

I love Excel's PIVOTBY function—but this one feature keeps me using PivotTables

PIVOTBY is great for analysis, but PivotTables still have the edge when formatting needs to adapt to data changes.
MUO on MSN

Two new Excel functions replaced every pivot table I used to build

Excel formulas are getting scary good.