Before you blame Excel, check whether your formulas are scanning a million empty rows.

Excel formulas are often seen as purely functional, but they can also serve as a space for documentation. My Online Training Hub highlights how embedding comments directly into formulas can enhance ...

Since Github doesn't provide a great way for you to learn about new releases and features, don't just star the repo, join the mailing list. dsq will likely work on other platforms that Go is ported to ...

Sifting through data just got easier with this quick and easy Excel formula.

Modern business intelligence demands speed, and utilizing AI tools for Excel is the ultimate way to hyper-charge your data workflows this year.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas (with or without help from the Copilot AI assistant) and ...

DuckDB is an amazing tool with deep integration with Python and R, but sometimes you just need data in Excel. xlDuckDb allows DuckDB SQL to be run within Excel. Query results are returned as regular ...

Because many password generators aren't as random as they seem, I built an improved one in Excel—and I'll show you exactly how you can, too. When the IBM PC was new, I served as the president of the ...

Microsoft Excel remains a cornerstone for data analysts, offering a wide array of functions to streamline workflows and enhance data accuracy. In this deep dive, Mo Chen highlights ten essential Excel ...

So far Excel users had three ways to invoke Copilot. Microsoft has now decided that was three too many. In February 2026, the company retired App Skills entry points from the Excel ribbon and context ...

Q. How do the TEXTBEFORE and TEXTAFTER functions in Excel work? A. Excel’s TEXTBEFORE and TEXTAFTER functions allow users to quickly split up text in ways that used to require combinations of ...

A new COPILOT function in Excel lets you use AI in a formula. The new skill is now available to Microsoft 365 insiders. Reduces some of the complexity involved in creating formulas. Get more in-depth ...