I have a love-hate relationship with spreadsheets and Excel.
Spreadsheets are good for ad-hoc tasks on small-to-medium amounts of data (let’s say the old 64k row limit) of medium-to-low complexity. In practice, that covers a lot of tasks.
The problem is that Excel is the only flexible tool many people have so they bend it to do everything in lieu of anything better.
I was a semi-power user once upon a time--even before Excel itself came on the scene. But latterly, spreadsheets were and are just a convenient way to create tabular information even if there aren't calculations involved, much less complex ones.