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

I used to waste hours in Microsoft Excel manually cleaning data, fixing formulas, and reformatting worksheets. That was until I realized I could use the Find and Replace dialog (Ctrl+H) to achieve the ...

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

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

Discover 8 2026 Excel updates, including AI formula creation and a year of change history, so your team works quicker with fewer mistakes.