I only need simple excel and mostly rely on word processing so I’ve never actually known what exactly ms excel has that libre doesn’t

Is it like actual macro/coding capabilities within excel or just convenience/file compatibility stuff?

For personal use, Libre office does everything I need. For work, Excel is an absolute beast. It doesn’t necessarily scale, but for those one off data comparison, manipulation, or validation often I can do it faster and easier than I can in SQL. VLookup was kinda cool. Index match is definitely powerful.

I still generally avoid the vb macros though I’ve found solutions online occasionally where they’re useful. (Reviewing the code to confirm it’s not malicious first of course.).

Fair, I still use Office 2007 via Wine. Even the newest one has the killer features (unless it's the awful web version) but your willingness to use it depends on how strong your aversion towards proprietary OSs and AI is

Since Google sheets came around I've always found freaking with excel more of a headache so I've not touched it for a loooong time. Only the reader version when someone sends me an xlsx in an email