Over here I wrote about a Microsoft Excel / Google Sheets function I only just discovered - LAMBDA().

It lets you define custom functions in terms of existing ones, allowing for a programming-free Turing-complete spreadsheet setup. There’s also a named function syntax available.