O'Reilly logo

Excel 2016 In Depth by Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required