How-To Geek on MSN

How to use the MAP function in Microsoft Excel

Row precision vs. Aggregation errors: MAP is the best way to use "greedy" functions like AND or OR in a single, dynamic ...
How-To Geek on MSN

Excel's UNIQUE function can't skip columns—unless you use this trick

Nest CHOOSECOLS inside UNIQUE to extract non-adjacent columns, and use INDIRECT for interactive header dropdowns.
PC Magazine

These 47 Expert Excel Tricks Will Transform You Into a Power User

Microsoft's spreadsheet program can do way more than you might imagine. These are the hacks and tricks you need to know. Our team tests, rates, and reviews more than 1,500 products each year to help ...
PC Magazine

These 47 Expert Excel Tricks Will Transform You Into a Power User

These 47 Expert Excel Tricks Will Transform You Into a Power User Microsoft's spreadsheet program can do way more than you might imagine. These are the hacks and tricks you need to know.