How-To Geek on MSN

Stop manually hiding Excel rows and columns for meetings: Use this hidden tool instead

Excel's Custom Views tool lets you create a snapshot of your spreadsheet, allowing you to toggle between layouts.

Learn What GROUPBY Can Really Do in Excel : From Smart Sorting to Percent of Totals

Learn how GROUPBY passes both subset and full arrays into LAMBDA in Excel, letting you compute percent shares fast and explain results clearly.