MrExcel on MSN

Excel WE LOOKUP 101: Finding Data Made Easy

This video explains the WE LOOKUP function in Excel and how it can be used to quickly find and return data from tables. It ...

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

Custom functions in Excel

Custom functions enable you to add new functions to Excel by defining those functions in JavaScript as part of an add-in. Users within Excel can access custom functions just as they would any native ...