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, ...