Question: how to udf in excel?
Answer: Open a new Excel workbook.
Get into VBA (Press Alt+F11)
Insert a new module (Insert > Module)
Copy and Paste the Excel user defined function examples.
Get out of VBA (Press Alt+Q)