10. Understanding Functions

Excel is used on 500 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 2013 offers 463 built-in calculation functions. This number grows with each new release. For example, 49 functions are new in Excel 2013. Some of these functions are invented by Microsoft. Some are added to keep Excel compliant with the Open Document Format standard.

Here are some interesting functions added in recent versions:

• Excel 2013 added the WEBSERVICE function to retrieve data from the Web. When it’s combined with the ENCODEURL ...

Get Excel® 2013 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.