While using Microsoft Excel for data analysis, you may sometimes need to search for and retrieve specific values. In such cases, Excel's LOOKUP function can be extremely useful. It allows you to ...

Build stable, high-performance dashboards using REPT formulas and UNICHAR symbols instead of conditional formatting.

BYROW replaces thousands of table formulas with one spill formula, making spreadsheets leaner and much more robust.

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 TRANSLATE function in Excel enables you to translate text into over 100 languages, covering a wide range of commonly spoken languages worldwide. This function is particularly useful for creating ...

Discover 15 modern Excel functions for 2026, including Group By and Scan, so you speed up your workflows, summaries and ...

Microsoft’s new Copilot function in Excel lets users generate, analyze and explain data directly from cell formulas, marking a major step toward full AI integration within spreadsheets. Microsoft’s ...

A little from column A, a little from column B: XLOOKUP is the new, easier way to retrieve information across Excel spreadsheets. If you’re working on your accounts and you need to convert all your ...

This post explains what is IFERROR function and how to use the function in Microsoft Excel. The IFERROR function was introduced in Excel as a logical function to handle errors that may occur within ...

If the Excel YEAR function is not working on your Windows 11/10 PC, change the cell format, convert text dates to real dates, ...

How to turn complex formulas into easy-to-use custom functions using LAMBDA() in Excel Your email has been sent LAMBDA functions are new to Microsoft Excel. With LAMBDA functions, you can turn a ...

The concatenate function may not be as well known as other common Excel features such as IF and VLOOKUP, but it’s still effective, even though it performs a more simple function in nature. If you are ...