Microsoft Excel 2019 Inside Out

Chapter 10Other Functions

Web Functions

Financial Functions

Statistical Functions

Trigonometry Functions

Matrix Functions

Engineering Functions

This chapter provides a reference to functions from the Web, Financial, Statistical, Trigonometry, Matrix, and Engineering functions.

Web Functions

Table 10.1 provides an alphabetical list of all the Web functions from Excel 2019.

Table 10.1 Alphabetical List of Web Functions

Function	Description
ENCODEURL(text)	Returns a URL-encoded string.
FILTERXML(xml, xpath)	Returns specific data from the XML content by using the xpath.
WEBSERVICE(url)	Returns data from a web service.

Inside OUT

These three functions are designed to work together, and they pre-date the new tools in Power Query. ...