Excel’s formula bar has limitations that make writing, debugging, and managing complex formulas challenging. A new tool, the Advanced Formula Environment (AFE), developed by Microsoft for Excel 2019 ...

Transform messy spreadsheets, remove errors, and refresh tables automatically without writing a single formula.

Build more efficient spreadsheets by using the dollar sign to lock specific rows, columns, or permanent addresses when referencing cells.

What if I told you that the tools you’ve relied on for years, VLOOKUP and XLOOKUP, might actually be holding you back? Sure, they’ve been the go-to formulas for countless Excel users, but as datasets ...

Microsoft is introducing a new AI-powered Copilot feature in Excel called "formula completion" to simplify the time-consuming process of writing formulas. Writing formulas in Microsoft Excel requires ...

How to combine values from a column into a single cell using Microsoft Excel’s Power Query Your email has been sent The article How to concatenate values in a single Excel column to a single row shows ...

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions. One of the ...

Microsoft has restarted its monthly feature round-up, detailing how Excel changed during January 2026 across Windows, Mac, and the web. The headline upgrade is Agent ...

If Excel is not using threads efficiently, calculations may take a long time to complete. Learn how to speed up calculating threads in Excel.