Being Excel the tool I (and I Think not only me) use mostly at workplace, I started to get into coding practicing VBA which stand for Visual Basic for Application (office package). I Think is unfair compare python coding vs sheets formula/function. These suits more for end user who are either beginner or simply, as you stated, are not going to tackle big dataset or doing some complicated stuff(Matrix formulas/unary operator can get you through more advanced stuff but is not going to save you nor are easily usable on large dataset). If you do need to work on a spreadsheet/multiple spreadsheet, workbooks and such I will always choose to work in VBA.I am starting to learn python and watching How to do Excel stuff with it its really usefull for the Learning path.
In presentations, I always compare Pandas to VBA (I describe it as "the easy syntax Excel's programming language should have been written with").
Lately, I've been trying to bang out a few supplemental bite-sized posts doing deep dives into easy tasks to which I can refer new students _(who are already looking into Python as a VBA alternative because they've hit a wall with Excel).
I should have thought about the fact that this needed a bit more context for strangers!
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.