I get what you're saying, but I would disagree that the focus should be on Excel and its UI/UX. As annoying as Excel is when you're working with _specific_ data that suffers from Excel's attempts to be helpful, I'd wager for most use cases Excel is doing exactly what most users expect it to, or the change is benign at best for most use cases.
That isn't to diminish when Excel's help has disastrous consequences, but rather to say it shouldn't be unexpected. If your data requires precision, there are better tools than Excel for working with your data and there should be steps taken by more experienced members of the team to ensure the team doesn't get bit by Excel's features. Excel's behaviors are well known and I'd have to imagine at least one member of any research team has been bitten by Excel's assistance features before during research. I would be surprised if any serious educational institution that teaches about ethics and common pitfalls in research *didn't* caution about how Excel might corrupt research [0].
0 - Okay, maybe not _that_ surprised, but I would be disappointed and think less of the institution/instructor.
That isn't to diminish when Excel's help has disastrous consequences, but rather to say it shouldn't be unexpected. If your data requires precision, there are better tools than Excel for working with your data and there should be steps taken by more experienced members of the team to ensure the team doesn't get bit by Excel's features. Excel's behaviors are well known and I'd have to imagine at least one member of any research team has been bitten by Excel's assistance features before during research. I would be surprised if any serious educational institution that teaches about ethics and common pitfalls in research *didn't* caution about how Excel might corrupt research [0].
0 - Okay, maybe not _that_ surprised, but I would be disappointed and think less of the institution/instructor.