15 Modern Excel Functions Worth Knowing in 2026 That Outclass Clunky Workflows

Discover 15 modern Excel functions for 2026, including Group By and Scan, so you speed up your workflows, summaries and ...

Power Query Isn’t Required: New Excel Functions Handle Straightforward Sources Cleanly

Use formulas instead of Power Query for tidy files, with a visible source path and clear parameters that teammates can review ...
How-To Geek on MSN

How to use the MAP function in Microsoft Excel

Use MAP and LAMBDA to build centralized, error-proof, and auto-spilling Excel spreadsheet systems.

Microsoft Excel’s new import functions make handling numbers easier

Excel now supports IMPORTTEXT and IMPORTCSV functions that load external text and CSV files as dynamic arrays, making it easier to refresh and reuse frequently updated data inside a worksheet. The ...
Hosted on MSN

StockHistory function becomes StockMystery as Microsoft Excel bugs out

For many, the start of a new year is a time to take stock. For Microsoft, it was a time to stop giving it as the company kicked off 2026 with a bug that broke Excel's StockHistory function.… A ...