Web
★ 12 · ◉ 14 · Excel 2013
=ENCODEURL()
The ENCODEURL function returns a URL-encoded string, replacing certain non-alphanumeric characters with the percentage symbol (%) and a hexadecimal number.
=ENCODEURL(text)
External Data, Web & Cube
Web
★ 12 · ◉ 13 · Excel 2013
=FILTERXML()
The FILTERXML function returns specific data from XML content by using the specified xpath.
=FILTERXML(xml, xpath)
Text Manipulation
External Data, Web & Cube
Cube
★ 35 · ◉ 12 · Excel 2007
=CUBEVALUE()
Returns an aggregated value from the cube.
=CUBEVALUE(connection, [member_expression1], [member_expression2], …)
Reporting
Dynamic Ranges & Dashboards
Cube
★ 12 · ◉ 11 · Excel 2007
=CUBESETCOUNT()
Returns the number of items in a set.
=CUBESETCOUNT(set)
External Data, Web & Cube
Web
★ 15 · ◉ 10 · Excel 2013
=WEBSERVICE()
The WEBSERVICE function returns data from a web service on the Internet or Intranet.
=WEBSERVICE(url)
External Data, Web & Cube
Cube
★ 8 · ◉ 9 · Excel 2007
=CUBEMEMBERPROPERTY()
The CUBEMEMBERPROPERTY function returns the value of a member property from a cube. Use it to validate that a member name exists within the cube, and to return the specified property for this member.
=CUBEMEMBERPROPERTY(connection, member_expression, property)
External Data, Web & Cube
Cube
★ 20 · ◉ 9 · Excel 2007
=CUBESET()
Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Excel.
=CUBESET(connection, set_expression, [caption], [sort_order], [sort_by])
External Data, Web & Cube
Web
★ 15 · ◉ 9 · Microsoft 365
=PY()
PY function
=PY(python_code,return_type)
External Data, Web & Cube
Cube
★ 30 · ◉ 8 · Excel 2007
=CUBEMEMBER()
Returns a member or tuple from the cube. Use to validate that the member or tuple exists in the cube.
=CUBEMEMBER(connection, member_expression, [caption])
External Data, Web & Cube
Lookup & Reference
★ 45 · ◉ 8 · All versions
=HYPERLINK()
The HYPERLINK function creates a shortcut that jumps to another location in the current workbook, or opens a document stored on a network server, an intranet, or the Internet. When you click a cell that contains a HYPERLINK function, Excel jumps to the location listed, or opens the document you specified.
=HYPERLINK(link_location, [friendly_name])
Dynamic Ranges & Dashboards
Worksheet Info & Navigation
Web
★ 15 · ◉ 8 · Microsoft 365
=IMPORTCSV()
IMPORTCSV function
=IMPORTCSV(path, [skip_rows], [take_rows], [locale])
External Data, Web & Cube
Lookup & Reference
★ 35 · ◉ 6 · Excel 365
=IMAGE()
The custom width of the image in pixels.
=IMAGE(source, [alt_text], [sizing], [height], [width])
Dynamic Ranges & Dashboards
External Data, Web & Cube
Web
★ 15 · ◉ 6 · Microsoft 365
=COPILOT()
COPILOT Function
External Data, Web & Cube
Web
★ 15 · ◉ 6 · Microsoft 365
=IMPORTTEXT()
IMPORTTEXT function
=IMPORTTEXT(path, [delimiter], [skip_rows], [take_rows], [encoding], [locale])
External Data, Web & Cube
Cube
★ 20 · ◉ 5 · Excel 2007
=CUBERANKEDMEMBER()
Returns the nth, or ranked, member in a set. Use to return one or more elements in a set, such as the top sales performer or the top 10 students.
=CUBERANKEDMEMBER(connection, set_expression, rank, [caption])
External Data, Web & Cube
Lookup & Reference
★ 15 · ◉ 4 · Excel for Microsoft 365
=FIELDVALUE()
The FIELDVALUE function can be used inside other formulas to extract field data from linked records. This article explains how.
=FIELDVALUE(value, field_name)
External Data, Web & Cube
Cube
★ 8 · ◉ 3 · Excel 2007
=CUBEKPIMEMBER()
Returns a key performance indicator (KPI) property and displays the KPI name in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, that is used to monitor an organization's performance.
=CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption])
External Data, Web & Cube