How to Create a User Defined Function in Microsoft Excel - wikiHow How to Create a User Defined Function in Microsoft Excel. Even when Excel has a lot, probably hundreds, of built in functions like SUM, VLOOKUP, LEFT, and ...