I've always hated excel. I'd much rather use R or Python. My first job used an Excel macro to automate tasks in a DOS emulator for some legacy software. It would take days to complete and would regularly crash. As they say, if all you have is a hammer everything looks like a nail.