Forum Discussion
List of Excel function available for Microsoft 365 Apps for business?
Where I can find such information', is there a link? I noticed for example that people having this version, don't have all the O365 excel functions such as TAKE, I would like to have access to the list of functions available for this version. Thanks
8 Replies
I believe a fully updated Semi Annual Channel (if that's your update channel) currently has access to all the functions, IMAGE excepted.
I'm not sure. 7 lambda helper functions (like MAP) were deployed on semi-annual 2208 in Jan, 2108 still without them. TAKE(), VSTACK() and other are still not on semi-annual.
Excel functions (alphabetical)
Click a letter to go to functions that start with it.
Worksheet functions are categorized by their functionality.
Excel keyboard shortcuts and function keys
BI capabilities in Excel and Office 365
Maybe these links will help you a bit.
As far as I know, there is no Excel list with all the formulas from Microsoft, since new improvements are constantly being offered for the formulas and at the same time formulas can differ greatly depending on the language.
For example, the formula IF in English is IF in German and other languages may be different.
The only table I can offer is the template I included from Microsoft's Formula Tutorial.Thank you for your understanding and patience
NikolinoDE Thanks for the information provided, but this is not what I am looking for. This is very generic information and not organized by version, and on top of that, not too much specific. For example take a look at ABS, I would say this function is available for Microsoft 365 Apps for business, but it is not specified. I prefer to use this reference page that is organized at least per release, but for this product there is no information.
To my knowledge there is no such summary. You may use "Check if a specific feature is in your version of Excel" here https://techcommunity.microsoft.com/t5/excel-blog/what-s-new-in-excel-february-2023/bc-p/3763627#M3396 or check release notes for your channel. For Current channel that is Release notes for Current Channel releases - Office release notes | Microsoft Learn , for other channels from menu on that page.
As a comment, in general concrete build number doesn't matter, check news for channels. Within channels new functionality is deployed gradually, it takes time. You may have the build for which new functionality is announced, but it could be not activated for you.
