7. Understanding 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 2016 offers 468 built-in calculation functions. This number grows with each new release. Excel 2016 introduced five new forecast functions used by the new Forecast Sheet command.
Working with Functions
To use functions successfully in a worksheet, you need to follow the function syntax. Keep in mind that a formula that makes use of a function needs to start with an equal sign. You type the function name, an opening parenthesis, function ...
Get Excel 2016 In Depth 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.
