Chapter 7Understanding 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 2019 offers 474 built-in calculation functions. This number grows with each new release. Excel 2019 debuts six new functions: CONCAT, IFS, MAXIFS, MINIFS, SWITCH, and TEXTJOIN. By the end of 2018, Office 365 introduced SORT, SORTBY, FILTER, UNIQUE, and SINGLE, bringing the function count to 479.

Working with Functions

To use functions successfully in a worksheet, ...

Get Microsoft Excel 2019 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.