[hankyone]

Everytime I have tried to use pivot tables I end up just firing PowerBI instead, it's a much better experience.

[jimnotgym]

It depends. It is common to use the results in further Excel calculations.

[bafe]

I usually end up using panda or R