MUO on MSN

I switched from pivot tables to GROUPBY formulas and my analysis updates itself

I can easily achieve the same result with a pivot table by dragging the Salesperson field into Rows and the Sales field into ...

MS Excel Slicers Without PivotTables : The Disconnected Table Trick

Learn the secret to building interactive Excel reports with slicers and disconnected tables—no PivotTable needed for dynamic ...
MUO on MSN

I use Excel's TAKE and DROP to make top-10 lists that update themselves

Here's how Excel processes that request. First, the SORT function arranges the entire table by sales amount in descending ...