Hosted on MSN

How to use the MAP function in Microsoft Excel

Excel's fill handle is fine for a few rows, but in a big dataset, it's an error waiting to happen. Why drag and drop when you can automate? The MAP function lets you ...
Hosted on MSN

Creating drop-downs from table headers in Excel seems impossible—but this trick fixes it

You've built a perfect Excel table, but the moment you try to use its headers in a drop-down menu, everything breaks. Excel's Data Validation is notoriously picky with tables, but there's a clever ...