I would be willing to be those people still knew how to do the job, just without Excel. They fundamentally understand the reason for "analyzing" things and the output generated by that.
It's when you put a recent MBA grad with 0 domain knowledge as the manager of these people where problems start.
And again, with the accountants. The crusty 60 year old accountant will still be able to read a report generated by a fresh college grad. He could even open the books and spot problems. Issues arise when you put someone who isn't an Accountant in charge of the other accountants.
But when your boss has never even made a model, let alone tried to fish data out of a database, then the kind of work he can imagine, his idea for time duration for work are all off.
More importantly, what he values in the team (for when it comes to promotions) is also likely to be off. And hence, you can end up in a situation where you don't get promoted despite being very good at your job.
It's when you put a recent MBA grad with 0 domain knowledge as the manager of these people where problems start.
And again, with the accountants. The crusty 60 year old accountant will still be able to read a report generated by a fresh college grad. He could even open the books and spot problems. Issues arise when you put someone who isn't an Accountant in charge of the other accountants.