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

Oh, I never said your reply as 'unhelpful'. The question below your reply reads 'Did this reply solve your problem? Yes No'

Answer 3

I have changed the content of my last reply. Do you have any other questions that we can help you with?

Looking forward to your reply.

Miyeon.S - MSFT |Microsoft Community Support Specialist

Answer 4

Thanks its really helpful ！ ╰(✿´⌣`✿)╯♡