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.

The SCAN function lives in a single cell and spills the results down the column, ensuring my totals are always structurally ...

The FIND function allows you to find a text string within another. It returns the position at which a character or string begins within another text string. The output of the above function will be 5, ...

Apple's Numbers spreadsheet for Mac, iPhone, and iPad, is not as powerful as Microsoft Excel, but most users will be hard-pressed to find its limitations — and will immediately see how much easier ...

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

Everyone on the planet has heard of Microsoft Excel. It’s the world’s analytical infrastructure. Estimates are that 1,500,000,000 people use Excel. Users love it at least twice a day and typically ...

If you are using Microsoft Excel to manage numerical data, at some point you're inevitably going to display percentages. Doing so can give you a new insight, or make summarizing heaps of data a bit ...

To kick things off, let’s explore how to perform essential calculations like determining the total salary and headcount by department. This is where functions such as `COUNTIFS`, `SUMIFS`, and ...

Microsoft Excel remains an essential tool for data management and analysis in businesses. With its numerous features, it can seem complex to master. To help you make the most of this software, ...

Struggling with managing large datasets in Excel? You’re not alone. Many users find themselves bogged down by repetitive tasks and complex formulas. But there’s good news! Excel offers advanced ...

We show you how to calculate percent change in Excel using a percentage change formula and some handy formatting tools. It can be beneficial in many situations to display the difference between two ...