Function library
Every Excel function
All 521 functions from Microsoft’s list, grouped the way Excel groups them. 500 run right here in the practice sheet; the rest come with step-by-step guides for desktop Excel.
Web
Talk to the internet and add-ins: ENCODEURL, WEBSERVICE, STOCKHISTORY.
6 functions
CALLRuns a function inside a Windows DLL. It is an old Excel 4 macro feature, kept only for very old workbooks.ENCODEURLURL-encodes textFILTERXMLPulls values out of XML text using an XPath, usually after WEBSERVICE downloads it.REGISTER.IDRegisters a DLL function and returns its ID so CALL can use it. Excel 4 macro feature for old workbooks.STOCKHISTORYDownloads historical prices for a stock, fund or currency pair from Microsoft’s data service.WEBSERVICEDownloads text (often XML or JSON) from a web address straight into a cell.