Chapter 7
Understanding functions
Getting help with Excel functions
Excel is used on 750 million desktops around the world. People in all career types use Excel, as do many home users who take advantage of Excel’s powerful features to track their finances, investments, and more. Part of Excel’s versatility is its wide range of built-in functions.
Excel offers 502 built-in calculation functions. This number grows with each new release. Recent additions to Excel include XLOOKUP, XMATCH, LET, LAMBDA, ARRAYTOTEXT, TEXTTOARRAY, MAP, REDUCE, SCAN, BYROW, BYCOL, and ISOMITTED.
Working with functions
To use functions successfully in a worksheet, you need to follow the function syntax. Keep in mind that a formula ...
Get Microsoft Excel Inside Out (Office 2021 and Microsoft 365) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
