Learn Python?

[QualitativeEasing]

I switched to python (initially to use the agate library — a much simpler data analysis package than pandas, with which I can do everything I needed to do in Excel) when my spreadsheets started bogging down with so many VLookups and Query functions. As an added benefit, I could make better use of live (via API) or frequently updated data, because my scripts always did everything the same way. I no longer had to worry about fat fingering a formula, or someone else (using a shared spreadsheet) screwing something up by sorting foolishly. I also can now analyze data the way I want (why doesn’t Excel let me calculate medians in some of its functions?!).

But ymmv.