How-To Geek on MSN

How to randomize rows in an Excel table without scrambling your data

Whether you're assigning random shifts, anonymizing a study, or shuffling a deck, randomizing rows in an Excel table manually ...

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.
How-To Geek on MSN

90% of Excel spreadsheets contain errors: Here’s how to fix yours

A common source of errors in Excel is "the gap"—a situation where you add new data to the bottom of a list, but your formulas ...

Master Sharpe Ratio Calculation in Excel for Better Investing

Learn to calculate the Sharpe Ratio in Excel for insightful investment analysis. Our guide will help you assess risk versus ...

How to Easily Calculate Weighted Average in Excel

Learn how to calculate weighted averages using Excel for various financial metrics. Simplify complex calculations with our ...
The Washington Post

Carolyn Hax

This mom didn’t know how to respond to attacks from a client’s wife on her decision to work outside the home. Carolyn Hax writes a daily advice column for The Post and has a weekly live online ...