Excel functions in Microsoft Office 2024?

Question

Hi.

What are all the Excel functions included in the recently released Microsoft Office 2024?

Post edit

Microsoft provided an alphabetical list of Excel functions. Which of these Excel functions are available in Microsoft Office 2024?

https://support.microsoft.com/en-us/office/excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188

Thanks for any info.

Answer 1

Hi, ChunkyDudi

Welcome to the Microsoft Community.

I've reviewed what you've posted and your replies to the “Miyeon.S” in thread.

If you want to learn about all of Excel 2024's functions, we still recommend that you check out this link to the official support article rather than an external link:

Excel functions (alphabetical) - Microsoft Support

In this link you can quickly find the function according to the alphabetical list and jump to the official support article description of the function. In contrast to external links, this link guarantees that the information you get is officially up-to-date and that Microsoft will not abandon this page even if the information is delayed for a short period of time, which is difficult to do with external links.

All the functions mentioned in this list are supported in Excel 2024.

At the same time, about the thing you mentioned that some functions are not shown on the introduction page to show which versions of Excel are supported (e.g., the XLOOKUP function), you can use this tag to assist in determining this:

This label represents the version of Excel introduced this function:

That is, in the case of the XLOOKUP function, for example, it is a function that was introduced with the Microsoft 365 version. It can be used in Excel 2021 and subsequent versions.

If a function is not labeled on the Function List page as to which version it was introduced in, and there is no indication of this on the separate page for this function, then by default this function is available in all versions of Excel mentioned below:

If you need further assistance, please contact me.

Best Regards, 

Mila.L-MSFT| Microsoft Community Support Specialist

Answer 2

Dear ChunkyDudi,

Thanks for visiting Microsoft Community.  I am happy to help you.

I understand that you want to know what functions are provided in Office 2024 Excel.

Thank you for your interest in Office 2024, the functions in the support article you provided are all the functions that are included in Office 2024 Excel, and the fact that Excel 2024 is labeled at the top of the support article indicates that the content in this support article applies to Excel 2024.

Excel 2024 adds New LAMBDA function and New IMAGE function, you can refer to this support article to see more information about these two functions:

What's new in Excel 2024 for Windows and Mac - Microsoft Support

In addition, Microsoft attaches great importance to user support experience, please feel free to mark “Yes” or “No” for my reply, so that when other users search for similar questions, this thread will be displayed first, which will help them quickly locate the answer.

Thank you for your cooperation. Please don't forget to contact the Microsoft community for future issues.

Best regards

Miyeon.S - MSFT |Microsoft Community Support Specialist

Answer 3

Thanks for your reply, Miyeon.S

I assume that the list has been updated already ?

So, by looking at the list we can determine if the function is available in Excel 2024 like the FILTER and SWITCH functions (red line in the attached image).

How about XLOOKUP function?

Answer 4

I was relying on the list like the one for SWITCH function wherein a similar 'list' is not present when I clicked on the XLOOKUP function article page.

Answer 5

The XLOOKUP function is included in Excel 2024, as you can see in the support article you provided. Clicking on “X” will automatically redirect you to the function with “x” as the first letter.

Best regards

Miyeon.S - MSFT |Microsoft Community Support Specialist