How-To Geek on MSN

How to use the LAMBDA helper functions in Microsoft Excel

Replace legacy formulas with MAP, BYROW, BYCOL, SCAN, and REDUCE to build secure, scalable, and automated spreadsheets.
How-To Geek on MSN

How to use the ISOMITTED function in Microsoft Excel

Build flexible Excel functions that automatically handle blanks, defaults, and overrides without messy nested IFs.
Geeky Gadgets

Master Advanced Excel Functions BYROW vs MAP vs SCAN vs REDUCE

The BYROW function is a powerful tool that applies a Lambda function to each row in your dataset. This function is particularly useful when you need to perform operations on a row-by-row basis. For ...
JournalofAccountancy

Say bye to PivotTables with Excel’s new PIVOTBY function

Q. Traditional PivotTables have always intimidated me. I see there is a new Excel function called PIVOTBY. What is the difference between it and the traditional PivotTable? With the PIVOTBY function, ...
JournalofAccountancy

Using Excel’s GROUPBY function as a PivotTable alternative

Q. Are there any alternatives to traditional PivotTables in Excel? A. The first thing that comes to mind is the function GROUPBY. The primary purpose of GROUPBY is to make data analysis easier by ...