How-To Geek on MSN

5 everyday actions that Power Query does better than regular Excel tools

Replace manual Excel tasks with conditional columns, smart merging, the unpivot tool, and more.
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.