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

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 ...
Hosted on MSN

What is ‘functional strategy?’ (And should functions even have strategies?)

Six years ago, I wrote (with colleague Jennifer Riel) a Harvard Business Review article on functional strategy. But the questions about functional strategy keep coming unabated. It is a vexatious ...

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

Understanding the 7 principles of functional programming

The object-oriented paradigm popularized by languages including Java and C++ has slowly given way to a functional programming approach that is advocated by popular Python libraries and JavaScript ...
Android Police

How to create and import named functions in Google Sheets

SUM and VLOOKUP are only a few of the functions Google Sheets offers for using mathematical formulas. When dealing with complex calculations, Apps Script can help you create a custom one. It's a ...