Chapter 10Other 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




Returns a URL-encoded string.

FILTERXML(xml, xpath)

Returns specific data from the XML content by using the xpath.


Returns data from a web service.

Get Microsoft Excel 2019 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.