Excel 365 Get and Transform Data (was Power Query, actually ETL) allows you to use the M language to create custom columns. Naturally enough I hoped with would either be Excelish or JavaScriptish but no, because it is specialised for report writing it is quite different and you have to learn a new language.
Here are some learning resources for M.
Dr James Bayley 