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

How I audit long Excel lists without looking at my screen

The visibility rule: Excel only says what it can see. If you use filters to hide specific rows, Excel skips over them ...
MrExcel on MSN

How to add the current time to a cell in Excel

Learn how to add the current time to a cell in Excel quickly and efficiently. This video shows multiple methods, including keyboard shortcuts and formulas, to automatically display the current time ...