Excel is extremely useful for the times where I don't want to think about all of the complex rules that are in my head, and I just want to transform the data and export it for people to use.
If I need to do things on an automated basis at 3am over 1 million records with tedious logic, ok time to code it