Excel is here to stay.

Get comfortable, and get up to speed. Couple this with asking your favourite generative AI tool for writing code and you're half of the way to a Data Scientist...

I always say that most simple apps could have been a spreadsheet - finally, I'm not even exaggerating.

The most popular coding language, Python, is now a callable function in Excel. Use the formula =PY(python_code,return_type) to run code and the function =xl() to reference data in the spreadsheet itself.

An example from the PY function entry on Microsoft Support:

=PY("xl(""Table1[#All]"", headers=True)",1)

The data is in a named Table, with a row of names, and the 1 denotes that we're outputting an Excel value.