I once needed to pivot a table. Tried it with excel, spent an hour googling, couldn't get it to work. Then exported it into SQL server, googled how to do it in T-sql, and was done shortly after.

Respect for people who work with excel, but it's not for me.