5 Power Query Custom Column Tips That Save Time : Master Nulls, Errors & Types

See how try and otherwise protect custom column math from type errors in Power Query, saving time and keeping your refresh ...
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

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

Any null values will show as blank cells in the final Excel table. If you'd prefer to fix this within the Power Query Editor, ...

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.
Telegram

Ray Mariano: Worcester schools manipulate numbers so all looks rosy

A few weeks ago, the school administration presented a report that confirmed what every teacher and many parents already knew: The Worcester public schools have a serious problem with student behavior ...