Microsoft's spreadsheet program can do way more than you might imagine. These are the hacks and tricks you need to know.
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.
How-To Geek on MSN
How to randomize rows in an Excel table without scrambling your data
Master row randomization in Excel using the classic helper column method or the dynamic SORTBY function.
Have you ever felt limited by the rigidity of Excel PivotTables when creating interactive reports? Many users assume that Excel slicers, the sleek, clickable filters that make data exploration a ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback