Diarmuid Early won first place in the 2025 Microsoft Excel World Championship. He has some pointers for using Excel at work.

Tables, named ranges, line breaks, modern functions, and helper columns make Excel formulas easier to read, audit, and fix.

Life is hectic, and juggling dozens of apps for the "must-do" chores adds to the noise. Since I already work in Excel daily, ...

Learn what the stated annual interest rate is and how to calculate it without compounding, plus how it compares to the effective annual rate.

When Andrew Grigolyunovich first started using Excel more than two decades ago, he never imagined the spreadsheet program would land him in Las Vegas or on ESPN. The Latvian financial consultant ...

Wouldn’t it be great if you could be an Excel wizard without putting in all the time and effort needed to learn how to get around Excel and make it do what you want it to do? Formulas are one of the ...

Daniel Jassy, CFA, is an Investopedia Academy instructor and the founder of SPYderCRusher Research. He contributes to Excel and Algorithmic Trading. Return on investment (ROI) measures the amount 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 ...

The agency’s commissioner has implied that some of their ingredients may be harmful. Is that true? By Alice Callahan and Teddy Rosenbluth Last week, the Food and Drug Administration convened a panel ...

Have you ever stared at a spreadsheet, struggling to make sense of percentage calculations that just don’t seem to add up? Whether it’s a confusing formula, a misstep with zero values, or an ...

In this post, we will show you how to calculate the expiry date in Microsoft Excel. Calculating expiry dates is a common requirement when working with Excel, especially for tracking inventory, ...

When working with large datasets in Excel, the performance of formulas plays a critical role in determining calculation speed and overall efficiency. Understanding which formulas perform best and how ...