EUROCONVERT Function in Excel: Convert Between Euro and Old Euro-Zone Currencies
EUROCONVERT converts between the euro and former national currencies (DEM, FRF, ITL …) at the fixed 1999-2002 rates. It needs the Euro Currency Tools…
Read article →Web, AI & Add-ins
Excel Web, AI & Add-ins functions explained with syntax, examples and common mistakes.
📊
← Excel
Web, AI & Add-ins
Excel Web, AI & Add-ins functions explained with syntax, examples and common mistakes.
📄 10 articles⬇️ 5 with practice files🕒 Updated 13 Oct 2026
🎓 Start here: Excel for India Course → 🎓 Start here: Excel Course: Beginner → Expert → 🎓 Start here: Bank Statement Automation →PY Function in Excel: Run Python Inside Excel
PY Function in Excel: Run Python Inside Excel
PY (Python in Excel, 2023) runs Python code (pandas, matplotlib and more) in Microsoft's cloud and returns the result to a cell. You don't…
Read article →ENCODEURL Function in Excel: Make Text Safe for a URL
ENCODEURL Function in Excel: Make Text Safe for a URL
TextLevel: IntermediateAvailable in: Excel 2013+ENCODEURL converts spaces and symbols into URL codes (%20 and so on).Syntax=ENCODEURL(text)ArgumentWhat it.
Read article →COPILOT Function in Excel: Ask AI Inside a Formula
COPILOT Function in Excel: Ask AI Inside a Formula
COPILOT (2025) sends a prompt plus the cells you reference to Microsoft's AI and returns the answer into the grid, e.g. classify feedback, summarise…
Read article →FILTERXML Function in Excel: Pick Values Out of XML
FILTERXML Function in Excel: Pick Values Out of XML
FILTERXML extracts values from XML with an XPath. Its famous side use: splitting text in versions without TEXTSPLIT.
Read article →DETECTLANGUAGE Function in Excel: Which Language Is This?
DETECTLANGUAGE Function in Excel: Which Language Is This?
DETECTLANGUAGE returns the language code of a text — useful for sorting customer feedback before translating it.
Read article →TRANSLATE Function in Excel: Translate Text in a Cell
TRANSLATE Function in Excel: Translate Text in a Cell
TRANSLATE uses Microsoft’s translation service to translate text between languages, right in the sheet.
Read article →CALL Function in Excel: Call a DLL Procedure
CALL Function in Excel: Call a DLL Procedure
CALL calls a procedure in a DLL or code resource. It is an old Excel 4.0 macro-era function, disabled by default for security and…
Read article →REGISTER.ID Function in Excel: ID of a Registered DLL Function
REGISTER.ID Function in Excel: ID of a Registered DLL Function
REGISTER.ID returns the register ID of a DLL function for CALL. Same legacy, same security restrictions.
Read article →WEBSERVICE Function in Excel: Read Data From a URL
WEBSERVICE Function in Excel: Read Data From a URL
WEBSERVICE downloads text from a web address (Windows desktop only). Combined with FILTERXML or TEXTAFTER it can read simple APIs.
Read article →