Re: "Surely an IT manager should know the difference between Word and Excel?"
If it works, it works.
If it works, but nobody know how it works, so changes cannot be made when required, it is a problem.
If it appears to be working, but is wrong, and nobody notices, it's a problem.
If it works, but in doing so, creates a lot of work for people to maintain it, when simpler, easy-to-use solutions exist, it's a problem.
If it works, but creates a bottleneck where only one person can make changes at a time, in a multi-user environment, it's a problem.
These are all real-world problems I have seen and had to deal with. Excel can get in the bin.
I mean, you can write a website using nothing but Notepad, but anyone who claims it's the tool for the job "because it works" is either a sadist or a masochist, depending on whether they are making someone else do that, or doing it themselves.