Stop Rewriting Formulas : Handle Functions Like Data in Excel and Power Query

Learn how Excel functions can act as data using LAMBDA, LET, and BYROW, so you reuse logic and cut formula edits.
MUO on MSN

I picked up basic VBA scripting and Excel suddenly got much better

If programming or scripting in general scares you, you don't need to worry either. You don't need to be a programming wizard ...